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

127 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
compilers153705(None) 
compiler1438371compiler_
compiles14311981compile_s
compliers1538291compliers
coilers93619902co__ilers
combiners15247942combiners
comparers15319392comparers
compeers143410012comp_eers
compellers1645192compellers
compile13312442compile__
compiled1537812compile_d
complier14310252complier_
complies14314522complie_s
composers153910622composers
computers15339752computers
copiers114215962co_pi_ers
couplers123311322coup_lers
boilers93417063bo__ilers
campers134220293camp__ers
campier133313273campi_er_
campiness1537543campiness
cavilers1348113c_avilers
ceilers93912533c__eilers
chapiters1635203chapiters
chompers17369593chomp__ers
coalers94419353co__alers
cobblers14359593co_bblers
coddlers12359173co_ddlers
codrivers1544863codrivers
cognizers2164433cognizers
coiler84421593co__iler_
coiners93620753co__iners
colliders12298073colliders
colliers103613583colli_ers
comakers16339173com_akers
combaters1538113combaters
combers134516623com__bers
combineds16255283combineds
combiner14259723combiner_
combines142814623combine_s
comelier12310653comelier_
comembers1744223comembers
comers105328083com___ers
comethers1637443comethers
comfier1439163comfi_er_
comfiness1646953comfiness
commies133718453commi_e_s
commixes2177353commixe_s
commoners15339783commoners
communers15338413communers
commuters15378913commuters
compacters18247023compacters
compadres16266413compadres
comparer143611363comparer_
compares143816433compare_s
compeer133811553comp_eer_
compeller1546293compeller_
compels133210883comp__els
compere134616623comp__ere
comperes143217973comp__eres
competes144117243compete_s
compiling1637763compiling
complainers1744473complainers
compleat14710153comp_leat
complect1659013comp_lect
complects1766413comp_lects
complete143412053comp_lete
completers16298323completers
completes153212923comp_letes
complex2037243comp_le_x
complexes22308103comp_lexes
complices1739253complices
complied1539673complie_d
complines15312833complines
complins14313113comp_lins
complots1438163comp_lots
composer145012953composer_
composes145017113compose_s
composters16388323composters
compotes144716513compote_s
compress1439053comp_ress
comprises15510943comprise_s
comprizes2468943comprize_s
computer144511513computer_
computes143914553compute_s
condolers122710573condolers
confiders1537483confiders
confiners1439953confiners
conifers133611703co_nifers
connivers1436933connivers
considers1238933considers
consolers112510923consolers
conspirers1444573conspirers
coolers93522493co__olers
coopers114019483coop__ers
copers104629843co_p__ers
copier103722893co_pi_er_
copies104130303co_pi_e_s
copilots1255753co_pilots
coppers133519753co_p_pers
coppices1638243coppice_s
copters113621283co_p_ters
corulers1039773co_rulers
cottiers10399153cotti_ers
coupler114713013coup_ler_
couples115317053coup_le_s
couplets12389873coup_lets
couriers103213173couri_ers
cowpies143314283cowpi_e_s
cowriters14317283cowriters
cripplers15314993cripplers
croupiers1334653croupi_ers
cupelers1266733c_upelers
cymbalers1842843cymbalers
empalers12226743_empalers
gospelers1273683gospelers
impalers12226973_impalers
mailers94420333__mailers
milers84625163__m_ilers
moilers93615203__moilers
oilers64721193_o__ilers
recompiles1645063recompile_s
rompers113412243romp__ers
samplers12299403samp_lers
smilers94113853_sm_ilers
toilers74116263to__ilers
vomiters1337203vom_iters

Search took 9 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.420425454.8
2DLD Change Limit1486411278.14318253.8
3Display Results1271270.0462760.9
 (SQL Overall)1786911278.60920756.3
 
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.