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

103 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
esquire1637660(None) 
enquire16287211enquire
esquired18315081esquired
esquires17266211esquires
squire155912461_squire
acquire1835602acquire
enquired18255792enquired
enquires17276972enquires
enquiry19254042enquiry
equine151711572e_quine
inquire16227992inquire
mesquite19537042mesquite
quire144917132__quire
require16148652require
square154513362_square
squired173710062_squired
squires163812842_squires
squirm17387672_squirm
squirt153812932_squirt
acquired2044043acquired
acquiree1944603acquiree
acquirer1944093acquirer
acquires1945403acquires
aspire8612123as_pire
asquint16208323asquint
assure6610773assu_re
desire7415303des__ire
empire1039323e_mpire
endure74014143endu_re
enquiries1854383enquiries
ensure63416003ensu_re
entire61617703e_ntire
enure53520223e_nu_re
equate152012463e_quate
equid154610323e_qui_d
equids16439143e_quids
equines161811593e_quines
equip16467263e_qui_p
equips17387193e_quips
equites162212493e_quites
equity1838103e_quity
escuage1035113escuage
eserine7415903eserine
esquiring19174023esquiring
estuary1034683estuary
expire1538023e_xpire
faquir1834313faquir_
faquirs1943863faquirs
gesture839243gestu_re
inquired18245933inquired
inquirer17235173inquirer
inquires17237363inquires
inquiry19254703inquiry
mesquit18387953mesqui_t
mesquites20476433mesquites
mesquits19496483mesquits
mezquite28354713mezquite
quare143920543__quare
quired163711953__quired
quires154015743__quires
quirk184011003__quirk
quirt144624233__quirt
quite144621463__quite
reacquire2043053reacquire
required18156833required
requirer17156113requirer
requires17168703requires
requite162012483requite
respire9411543res_pire
satire63218003_satire
secure8513533secu_re
sequin1538523sequi_n
sequined18105653sequined
sequins1637863sequins
shire84727133_s_hire
sire46150413_s__ire
sluice849513_sluice
spire75828693_s_pire
squared173610563_squared
squarer163410663_squarer
squares163714463_squares
squark19438113_squark
squib163710503_squi_b
squibs17317453_squibs
squid154211903_squi_d
squids16409803_squids
squill1537233_squill
squint154214793_squint
squireen1744393_squireen
squirmed2034173_squirmed
squirmer1934373_squirmer
squirms18376343_squirms
squirmy21374293_squirmy
squirrel17414533_squirrel
squirted1845793_squirted
squirter1746523_squirter
squirts16348013_squirts
squish1838573_squish
sucre75019103_s_ucre
suite54829563_s_uite
sure45447413_s_u_re
usque14137733usqu__e
vesture10310373vestu_re

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271038.17016404.8
3Display Results1031030.0462239.1
 (SQL Overall)1786911038.37221343.9
 
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.