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

146 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
computers1533975(None) 
commuters15378911commuters
computer144511511computer_
computes143914551compute_s
combaters1538112combaters
communers15338412communers
commuter143010152commuter_
commutes143011892commute_s
compacters18247022compacters
comparers15319392comparers
compeers143410012comp_eers
competes144117242compete_s
compilers1537052compilers
completers16298322completers
compliers1538292compliers
composers153910622composers
composters16388322composters
compotes144716512compote_s
compute134513662compute__
computed154110952compute_d
computerese17183412computerese
computerise17285532computerise
computerist17205802computerist
confuters1437792confuters
copters113621282co_p_ters
couters93827302co__uters
imputers1235822_imputers
amputees1245103_amputees
campers134220293camp__ers
campuses1437773campuse_s
cementers1338313cementers
chapiters1635203chapiters
chapters154012133chap_ters
chompers17369593chomp__ers
clouters10399803c_louters
coasters104317333co_asters
coaters93525793co__aters
cointers103616413co_inters
colluders12285613colluders
colourers1136473colourers
colters93522443co__lters
comakers16339173com_akers
comates114123643com_ate_s
combater1439383combater_
combers134516623com__bers
combiners15247943combiners
combustors1643753combustors
comembers1744223comembers
comers105328083com___ers
comethers1637443comethers
comforters17275193comforters
commenters16139483commenters
commoners15339783commoners
communer14349303communer_
communes143411243commune_s
commute134310443commute__
commuted15288983commute_d
compacter17257883compacter_
compactors18256253compactors
compadres16266413compadres
comparer143611363comparer_
compares143816433compare_s
compeer133811553comp_eer_
compellers1645193compellers
compels133210883comp__els
compere134616623comp__ere
comperes143217973comp__eres
compete134716553compete__
competed154113593compete_d
competent15411253competent
compiler1438373compiler_
compiles14311983compile_s
completer153310413completer_
completes153212923completes
complier14310253complier_
complies14314523complie_s
composer145012953composer_
composes145017113compose_s
composter15369563composter_
compote135616463compote__
compounders1843143compounders
compress1439053comp_ress
compted143813523comp_te_d
compts125216653comp_t__s
computerdom2061923computerdom
computerdoms2161773computerdoms
computereses18162783computereses
computerised19193693computerised
computerises18224973computerises
computerists18193913computerists
computerize26214813computerize
computerizes27234443computerizes
computerless1852203computerless
computernik2151953computernik
computerniks2261863computerniks
computing16309853computing
computist1547323computist
computists1644693computists
comtes106222813com__te_s
conducers14136563conducers
confuter1338513confuter_
confutes1339843confute_s
conjurers18126233conjurers
conquers1938223conqu_ers
consulters1297213consulters
consumers1337203consumers
coopers114019483coop__ers
cooters94525723co__oters
copers104629843co_p__ers
copiers114215963co_p_iers
coppers133519753co_p_pers
copter109822013co_p_ter_
corpuses12310063corpuse_s
corrupters1444023corrupters
corulers1039773co_rulers
costers94128333co__sters
costumers1374853costumers
cotters94323443co__tters
coulters103614313co_ulters
counters103320193co_unters
couplers123311323coup_lers
courters103015373co_urters
couter84930223co__uter_
coveters132411083co_veters
cowriters14317283cowriters
dempsters1435273dempsters
disputers1236613disputers
dumpsters1453743dumpsters
fomenters1437853fomenters
hoopsters1445693hoopsters
imputer1136533_imputer_
imputes1138083_impute_s
omitters10277653_omitters
outers64230173_o__uters
polluters1135033polluters
pouters94221873po__uters
prompters1537553promp_ters
recomputes1644873recompute_s
rompers113412243romp__ers
routers74822873ro__uters
scouters103411323sco__uters
souters74422603so__uters
sumpters1238023sump_ters
tempters12257293temp_ters
touters74018353to__uters
vomiters1337203vom_iters

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411466.61022487.3
3Display Results1461460.0602433.3
 (SQL Overall)1786911467.09325192.6
 
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.