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

59 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
equerry194305(None) 
quarry1837472_quarry
query174212082_que_ry
berry104521773__berry
blurry11437673blu_rry
burry105221563_bu_rry
cherry144810763_cherry
coquetry2243563coquetry
curry105920343_cu_rry
derry94721373__derry
dewberry1742403dewberry
eagerly1136053eagerly
eatery95316353eate_ry
eery76129623e__e_ry
elderly1154953elderly
elusory1083993elusory
emery104814333e_me_ry
empery1348683empe_ry
energy10137513e_nergy
enquiry19254043enqu_iry
equably2136183equably
equally1936873equally
equerries1844883equerries
equity1838103equ_ity
every115215453e_ve_ry
ferry116020803__ferry
flurry12397113flu_rry
furry116719283_fu_rry
gurry94515413_gu_rry
herry114922473__herry
hurry114917183_hu_rry
jerry155016183__jerry
kerry124916093__kerry
merry104721493__merry
murry105120233_mu_rry
perry105222713__perry
queasy1855173_queasy
queazy2743573_queazy
queer143712813_queer_
queerly1934233_queerly
queers153510773_queers
quern143610403_que_rn
querns15307943_querns
quey164616473_que__y
quirky22435533_quirky
qwerty2133583_qwerty
scurry11419593scu_rry
sequency2244493sequency
serry84824123__serry
sherry124510413_sherry
skerry13356103_skerry
slurry9378603slu_rry
spurry11429123spu_rry
squeaky2343083squeaky
squirmy21374293squirmy
teaberry1343293teaberry
terry84721873__terry
unmerry1245023unmerry
wherry15477333_wherry

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.406440125.6
2DLD Change Limit134027597.25018486.5
3Display Results59590.0134538.5
 (SQL Overall)178691597.66923300.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.