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

61 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
enquiry1925404(None) 
enquire16287211enquire
inquiry19254701inquiry
enquired18255792enquired
enquires17276972enquires
equity1838102e_quity
esquire16376602esquire
inquire16227992inquire
acquire1835603acquire
annuity1045543annuity
century1237193centu_ry
enduing9249723enduing
endure74014143endu_re
enduro7338623endu_ro
engird8126973en_gird
engirt71112613en_girt
enmity1137483en_mity
ennui537523ennui__
ennuis636473ennui_s
enquiries1854383enquiries
enquiring19175443enquiring
ensuing8239543ensuing
ensure63416003ensu_re
entire61617703en_tire
entity9312053en_tity
entry82414263en__try
enure53520223en_u_re
enviro936303en_viro
equerry1943053e_querry
equid154610323e_qui_d
equids16439143e_quids
equine151711573e_quine
equip16467263e_qui_p
equips17387193e_quips
esquired18315083esquired
esquires17266213esquires
estuary1034683estuary
expiry1834653e_xpiry
faquir1834313faquir_
faquirs1943863faquirs
inequity2044553inequity
iniquity2044473iniquity
injury16266143inju_ry
inquiet16311413inquiet
inquired18245933inquired
inquirer17235173inquirer
inquires17237363inquires
liquify2244033liquify
penury1148103pen_u_ry
query174212083__query
quire144917133__quire
quirk184011003__quirk
quirky22435533__quirky
quirt144624233__quirt
require16148653require
squire155912463_squire
squirm17387673_squirm
squirmy21374293_squirmy
squirt153812933_squirt
tenuity1037453ten_uity
unquiet16310663unquiet

Search took 7 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 Limit134027616.04622167.9
3Display Results61610.0302033.3
 (SQL Overall)178691616.23228673.1
 
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.