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

51 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
inquiry1925470(None) 
enquiry19254041enquiry
inquire16227991inquire
enquire16287212enquire
inequity2044552inequity
iniquity2044472iniquity
injury16266142inju_ry
inquiet16311412inquiet
inquired18245932inquired
inquirer17235172inquirer
inquires17237362inquires
acquire1835603acquire
annuity1045543annuity
enquired18255793enquired
enquires17276973enquires
equity1838103_equity
esquire16376603esquire
faquir1834313faquir_
faquirs1943863faquirs
inanity1039503inanity
inbuilt947323inbuilt
incur72212253incu_r_
incurs83012283incu_rs
induing91910943induing
industry1243573industry
infirm1137043in_firm
injure133410863inju_re
inquest1638603inquest
inquiets1745433inquiets
inquirers18234013inquirers
inquiries1855523inquiries
inquiring19155643inquiring
inspire938253inspire
insure63416603insu_re
intuit6314083intui_t
intuits7310313intuits
inturn63411563intu_rn
inure54119053in_u_re
inurn53712863in_u_rn
liquify2244033liquify
query174212083__query
quire144917133__quire
quirk184011003__quirk
quirky22435533__quirky
quirt144624233__quirt
require16148653require
squire155912463_squire
squirm17387673_squirm
squirmy21374293_squirmy
squirt153812933_squirt
unquiet16310663unquiet

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 Filter1786911340270.436409841.7
2DLD Change Limit134027516.78319759.3
3Display Results51510.0301700.0
 (SQL Overall)178691517.24924650.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.