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 “computer” 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.

183 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
computer14451151(None) 
commuter143010151commuter
compute134513661compute_
computed154110951computed
computers15339751computers
computes143914551computes
combater1439382combater
communer14349302communer
commute134310442commute_
commuted15288982commuted
commuters15378912commuters
commutes143011892commutes
compacter17257882compacter
comparer143611362comparer
compeer133811552comp_eer
compete134716552compete_
competed154113592competed
competes144117242competes
compiler1438372compiler
completer153310412completer
complier14310252complier
composer145012952composer
composter15369562composter
compote135616462compote_
compotes144716512compotes
compted143813522comp_ted
confuter1338512confuter
copter109822012co_p_ter
couter84930222co__uter
imputer1136532_imputer
amputee1148863_amputee
camper124722213camp__er
campier133313273camp_ier
campused1535253campused
campuses1437773campuses
cementer1239193cementer
chapiter1536603chapiter
chapter144213853chap_ter
chomper163810073chomp__er
clouter93511693c_louter
coapted123911503coap_ted
coaster94219043co_aster
coater84329573co__ater
coempted1535333coemp_ted
cointer93616723co_inter
colluder11276873colluder
colourer1037563colourer
colter84625093co__lter
comaker153410603com_aker
comate104124843com_ate_
comates114123643com_ates
combated1539823combated
combaters1538113combaters
comber125118503com__ber
combiner14259723combiner
combusted1644643combusted
combustor1543703combustor
comelier12310653comelier
comember1644163comember
comer95832693com___er
comether1537253comether
comfier1439163com_fier
comforter16255983comforter
commenter151410693commenter
commoner142710633commoner
commune13329363commune_
communed15338213communed
communers15338413communers
communes143411243communes
compacted18297363compacted
compacters18247023compacters
compactor17256023compactor
compadre15295883compadre
compare135814993compare_
compared153811823compared
comparers15319393comparers
compares143816433compares
comparted16338423comparted
comped135919873comp__ed
compeers143410013comp_eers
compel124412893comp__el
compeller1546293compeller
compere134616623comp__ere
compered153414923compered
comperes143217973comperes
competent15411253competent
compile13312443compile_
compiled1537813compiled
compilers1537053compilers
compiles14311983compiles
complete143412053complete
completed162810273completed
completers16298323completers
completes153212923completes
complex2037243comp_lex
complexer22316213complexer
complied1539673complied
compliers1538293compliers
complies14314523complies
compone136517193compone_
comported16319533comported
compose135716663compose_
composed154612063composed
composers153910623composers
composes145017113composes
composted16378813composted
composters16388323composters
compounder1743433compounder
compt116328223comp_t__
compts125216653comp_t_s
computerdom2061923computerdom
computerese17183413computerese
computerise17285533computerise
computerist17205803computerist
computerize26214813computerize
computernik2151953computernik
computing16309853computing
computist1547323computist
comte96125473com__te_
comtes106222813com__tes
conducer13127373conducer
confute1239263confute_
confuted1437683confuted
confuters1437793confuters
confutes1339843confutes
conjurer17117683conjurer
conquer1838623conqu_er
consulter1198223consulter
consumer1238503consumer
cooper104221123coop__er
coopted123710763coop_ted
cooter85128613co__oter
coper95336093co_p__er
copier103722893co_p_ier
copper124321893co_p_per
copters113621283co_p_ters
copular113810603co_pular
cornute939643cornute_
cornuted1137473cornuted
corpuses12310063corpuses
corrupter1344543corrupter
coruler9311713co_ruler
coster84331293co__ster
costumer1275103costumer
cotter84926673co__tter
coulter94115603co_ulter
counter94220153co_unter
coupler114713013coup_ler
courter94516483co_urter
couters93827303co__uters
couther123914633co__uther
coveter122912063co_veter
cowriter13238883cowriter
cuter74728233c___uter
dempster1355773dempster
disputer1137973disputer
dumpster1344053dumpster
fomenter1339263fomenter
hoopster1335543hoopster
impurer1136483_impurer
impute1038043_impute_
imputed1236533_imputed
imputers1235823_imputers
imputes1138083_imputes
muter74525543__m_uter
noncomputer1754083noncomputer
omitter9298503_omitter
outer55633303_o__uter
polluter1035403polluter
pouter83923983po__uter
precomputer1952923precomputer
prompter1437983promp_ter
recompute1544713recompute_
recomputed1744723recomputed
recomputes1644873recomputes
romper104213683romp__er
router65025843ro__uter
scouter93313323sco__uter
souter64225923so__uter
sumpter1138873sump_ter
tempter11358213temp_ter
touter63821033to__uter
vomiter1237953vom_iter

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621836.96620982.2
3Display Results1831830.0802287.5
 (SQL Overall)1786911837.46923924.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.