Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “incomer” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

208 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
incomer116994(None) 
income10712091income_
incomers1268591incomers
incomes11712371incomes
comer95832692__comer
encoder1038632encoder
incher114114032inc_her
inciter93113772inciter
incloser10106732incloser
incumber1444552incumber
informer13227282informer
inhumer1275382inhumer
intoner7811672intoner
invoker1435362invoker
ionomer939832ionomer
isomer8310152i_somer
uncover1239002uncover
winsomer1345772winsomer
ancone83916953ancone_
ancones93116343ancones
annoyer1095603annoyer
become123312593become_
becomes132911963becomes
bloomer11419813bloomer
boomer104618513_boomer
buxomer1833243buxomer
coder86134223__coder
comber125118503__comber
come87547703__come_
comers105328083__comers
comes97246993__comes
comet95946073__comet
cooer74831013__cooer
coper95336093__coper
corer75538873__corer
cover105430773__cover
cower104531773__cower
coyer105222843__coyer
decoder113712293decoder
decoyer13348683decoyer
discover1439563discover
encloser10107193encloser
encode9310443encode_
encoded1139043encoded
encoders1137513encoders
encodes10310643encodes
encomia1147983encomia
encore8314773encore_
encored10412113encored
encores9315213encores
encumber1454143encumber
endower1138483endower
enjoyer1744383enjoyer
enrober9218623enrober
excimer1834963excimer
gnome84213953gn_ome_
gnomes93812973gn_omes
gomer85220653__gomer
groomer10399873groomer
homer105828453__homer
icemen1037893i_cemen
icier74313753i_c_ier
icker114018443i_c_ker
ickier12439923i_ckier
icones84616383i_cones
ignorer8276103ignorer
imbower14235663imbower
imposer113310103imposer
impower14247123impower
inaner62213543in_aner
inarmed10268673inarmed
incage93513623incage_
incaged114010443incaged
incages103013883incages
incase83615283incase_
incased103612393incased
incases93615973incases
incenter102212093incenter
inched124514483inc_hed
inchers123912523inc_hers
inches114419673inc_hes
inchmeal1543663inchmeal
incise83515333incise_
incised102911583incised
incises93414893incises
incisor955323incisor
incite83618733incite_
incited103314623incited
inciters103210673inciters
incites93218483incites
incliner1038513incliner
inclose9910223inclose_
inclosed1197623inclosed
inclosers11155563inclosers
incloses101610533incloses
incog838253inco__g
incogs937903inco_gs
incoming1349863incoming
inconnu945053inconnu
incony1139083inco_ny
incudes10319523incudes
incumbers1544003incumbers
incur72212253inc__ur
incuse83513573incuse_
incused102911173incused
incuses93514853incuses
indexer15287253indexer
inditer83514233inditer
indole74516053indole_
indoles83716363indoles
indoor738403indo_or
indorser985713indorser
indowed1237443indowed
inducer10318763inducer
infer84215033in__fer
inflamer1356123inflamer
infolder1256433infolder
informed14197673informed
informers14206133informers
infuser10298323infuser
ingoted939183ingoted
inhaler1068053inhaler
inholder1276113inholder
inhume1196583inhume_
inhumed1375573inhumed
inhumers1364823inhumers
inhumes1296883inhumes
injurer14318473injurer
inker94421093in__ker
inkier104013783in_kier
inlayer1036933inlayer
inlier63615363in_lier
inner54920633in__ner
inpour837063inpo_ur
insaner7310443insaner
insider849733insider
insofar1043543insofar
insole63515863insole_
insoles73516243insoles
insurer73312803insurer
integer837993integer
inter55028493in__ter
intime81014273intime_
intomb1036403intom_b
intombed1363733intombed
intombs1144153intombs
intone61115433intone_
intoned8811993intoned
intoners889933intoners
intones7816543intones
invader11146453invader
inviter104112313inviter
invoke1336213invoke_
invoked1535303invoked
invokers1534673invokers
invokes1436383invokes
involver1444663involver
inwove12167273inwove_
inwoven13175523inwoven
ionomers1038503ionomers
ironer64216453i_roner
isomers9310043i_somers
itchier12247673itchier
knocker12296393knocker
knower1337083kn_ower
mincer104017363minc__er
mincier113512473minc_ier
misnomer1247143misnomer
monomer11311893monomer
namer75622103_n_amer
newcomer1543343newcomer
nicer74618293nic__er
nicker123818703nic_ker
nome66038423_n_ome_
nomen75621623_n_omen
nomes74933123_n_omes
nooser65517823_nooser
noter55025643_n_oter
oinomel946353oin_omel
omer67028393___omer
pincer104019173pinc__er
pincher143812713pinc_her
ransomer1047883ransomer
recover124312623recover
roomer84718633_roomer
scorer84818263_scorer
scoter83815483_scoter
sincerer1037203sincerer
snooker113910303snooker
snooper93511533snooper
snoozer16409193snoozer
snorer64316763sn_orer
uncoded11312743uncoded
uncombed1536323uncombed
uncomely1545363uncomely
uncomic1346923uncomic
uncovers1336573uncovers
undoer73113043undo_er
unsober967643unsober
venomer1237583venomer
vocoder1334693vocoder
vomer105517383__vomer
welcomer1544033welcomer
wincer115018193winc__er
wincher153410653winc_her
wingover1544303wingover
winnower1444253winnower
winsome1237463winsome_

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.420425454.8
2DLD Change Limit1340272086.65620136.3
3Display Results2082080.0802600.0
 (SQL Overall)1786912087.15624970.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.