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

107 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
esquires1726621(None) 
enquires17276971enquires
esquire16376601esquire_
esquired18315081esquired
squires163812841_squires
acquires1945402acquires
enquire16287212enquire_
enquired18255792enquired
enquiries1854382enquiries
equines161811592e_quines
equites162212492e_quites
inquires17237362inquires
mesquites20476432mesquites
quires154015752__quires
requires17168702requires
squares163714462_squares
squire155912462_squire_
squired173710062_squired
squirms18376342_squirms
squirts16348012_squirts
acquire1835603acquire_
acquired2044043acquired
acquiree1944603acquiree
acquirees2043103acquirees
acquirer1944093acquirer
acquirers2043413acquirers
aspires9612043as_pires
assures7611403assu_res
desires81316133des__ires
empires1139853e_mpires
endures83314603endu_res
enquiry19254043enquir_y
ensures73315903ensu_res
entires71517783e_ntires
enures63919713e_nu_res
equates162012323e_quates
equids16439143e_qui_ds
equine151711573e_quine_
equips17387193e_qui_ps
equities17310773e_quities
escuages1145163escuages
eserines8413743eserines
espies83716803es_pi_es
esquiring19174023esquiring
estuaries946213estuaries
exequies2444153exequi_es
expires1638683e_xpires
faquirs1943863faquir_s
gestures9310013gestu_res
inquire16227993inquire_
inquired18245933inquired
inquirer17235173inquirer
inquirers18234013inquirers
inquiries1855523inquiries
mesquite19537043mesquite_
mesquits19496483mesqui_ts
mezquites29374023mezquites
quire144917133__quire_
quired163711953__quired
quirks19419113__quirks
quirts154213553__quirts
reacquires2142993reacquires
require16148653require_
required18156833required
requirer17156113requirer
requirers18165003requirers
requites171511763requites
respires10311903res_pires
satires72617573_satires
sauries72821623_sauries
secures9613163secu_res
sequined18105653sequined
sequins1637863sequi_ns
shires95225573_s_hires
sires55945373_s__ires
sluices959073_sluices
spires84628113_s_pires
square154513363_square_
squared173610563_squared
squarer163410663_squarer
squarers17338023_squarers
squarest17338223_squarest
squarks20417183_squarks
squibs17317453_squi_bs
squids16409803_squi_ds
squills1666313_squills
squints16339033_squints
squireen1744393_squireen
squireens1842733_squireens
squirish2045113_squirish
squirm17387673_squir_m
squirmed2034173_squirmed
squirmer1934373_squirmer
squirmers2053113_squirmers
squirmy21374293_squirmy
squirrel17414533_squirrel
squirrels18333423_squirrels
squirt153812933_squir_t
squirted1845793_squirted
squirter1746523_squirter
squirters1835073_squirters
squishes20198393_squishes
sucres84218893_s_ucres
suites63727403_s_uites
usques15126803usqu__es
usuries7510633us_uries
vestures11311043vestu_res

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 Limit1461621077.50019488.3
3Display Results1071070.0303566.7
 (SQL Overall)1786911077.95322468.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.