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 “esquired” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
esquired1831508(None) 
enquired18255791enquired
esquire16376601esquire_
esquires17266211esquires
squired173710061_squired
acquired2044042acquired
enquire16287212enquire_
enquires17276972enquires
inquired18245932inquired
quired163711952__quired
required18156832required
sequined18105652sequined
squared173610562_squared
squire155912462_squire_
squires163812842_squires
squirmed2034172_squirmed
squirted1845792_squirted
acquire1835603acquire_
acquiree1944603acquiree
acquirer1944093acquirer
acquires1945403acquires
aspired1068173as_pired
assured858373assu_red
desired9311983des__ired
despaired1344503despaired
endured93611213endu_red
enquiries1854383enquiries
enquiry19254043enquir_y
ensured83512943ensu_red
enured73315333e_nu_red
equaled17166923e_qualed
equated171910403e_quated
equid154610323e_qui__d
equine151711573e_quine_
equines161811593e_quines
equipped2243073e_quipped
equites162212493e_quites
espied9359773es_pi_ed
esquiring19174023esquiring
expired1736403e_xpired
gestured1036993gestu_red
inquire16227993inquire_
inquirer17235173inquirer
inquires17237363inquires
liquored1842883liquored
mesquite19537043mesquite_
mesquites20476433mesquites
quire144917133__quire_
quires154015753__quires
quirked21325433__quirked
quirted17369213__quirted
reacquired2242623reacquired
require16148653require_
requirer17156113requirer
requires17168703requires
requited18169723requited
respired1148993res_pired
secured1059723secu_red
sequinned1982413sequinned
sired66134283_s__ired
sluiced1046053_sluiced
slurred8359193_slurred
soured74921863_sou_red
speired103811103_speired
spired94921863_s_pired
spurred103610623_spurred
square154513363_square_
squarer163410663_squarer
squares163714463_squares
squibbed2283423_squibbed
squid154211903_squi__d
squidded2043723_squidded
squiffed2433733_squiffed
squinted1847063_squinted
squireen1744393_squireen
squirm17387673_squir_m
squirmer1934373_squirmer
squirms18376343_squirms
squirmy21374293_squirmy
squirrel17414533_squirrel
squirt153812933_squir_t
squirter1746523_squirter
squirts16348013_squirts
squished21186393_squished
suited74019423_s_uited
unsquared1944073unsquared
vestured1237463vestu_red

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 Limit146162876.62622058.9
3Display Results87870.0302900.0
 (SQL Overall)178691877.07925242.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.