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

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

92 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
faery11601548(None) 
aery77231681_aery
fairy115318281fairy
fakery16509261fakery
fiery114714791fiery
aero45435342_aero
airy75734152_airy
apery106517902apery
awry107619682_awry
bakery155911002bakery
beery105220122beery
carry105823782carry
dairy97016302dairy
deary95826842deary
eatery95316352eatery
eery76129622_eery
emery104814332emery
every115215452every
facer105525052facer_
facers115519442facers
faddy135511622faddy
fader94421512fader_
faders105117462faders
faena85014202faena
faerie93514682faerie
faggy136514372faggy
fair76332522fair_
fairly125610012fairly
fairs85825442fairs
faker124824592faker_
fakers134219532fakers
fakey155515422fakey
fancy134615482fancy
fanny114816042fanny
far67762602fa_r_
farcy135217092farcy
fard85639062fa_rd
fare76354462fa_re
fared95842342fared
farer86733142farer
farers95924052farers
fares85852872fares
farl76338552fa_rl
farm95934532fa_rm
faro76136922fa_ro
fart76860562fa_rt
fatly115716802fatly
fatty115117412fatty
fawny144711712fawny
fay97454862fa__y
fear75337792fear_
fears84829392fears
fer66646122f_er_
fere76342232f_ere
ferly115517352f_erly
fern76129322f_ern
ferny115816182f_erny
ferry116020802ferry
fey95940882f_e_y
finery124512892finery
firry115713532firry
fleury12417352fleury
fley106626852fle_y
frere85617722frere
fry96226502f__ry
furry116719282furry
fury107727972f_ury
hairy115316832hairy
harry115322952harry
japery18439142japery
kaury12429762kaury
leary85927382leary
leery85919132leery
marry104821692marry
napery11489812napery
nary76931222na_ry
onery8414122onery
papery134812742papery
parry105323752parry
peery105719442peery
query174212082query
saury84317222saury
tarry85422512tarry
teary85124052teary
vary105226062va_ry
veery115816252veery
very108025642_very
wafery15398692wafery
wary106740012wa_ry
watery123914492watery
wavery154610052wavery
weary115620612weary

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit53800921.42337807.4
3Display Results92920.0303066.7
 (SQL Overall)178691921.763101356.2
 
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.