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

77 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
unfaith134578(None) 
unfaiths1443211unfaiths
faith115620852__faith
unearth1037062unearth
unfair936232unfai_r
unfit84518562unf_it_
unfits93910292unf_its
baith108023133__baith
faiths124610273__faiths
frith115922033__frith
funfair1342033funfai_r
funfairs1442133funfairs
gunsmith1442763gunsmith
inearth1037043inearth
infant92315133infant_
infanta10237253infanta
infante101910883infante
infants102210773infants
laith85722103__laith
misfaith1644543misfaith
neath86020283_nea_th
saith85826553__saith
snath86419803sn_a_th
sunbath1236423sunba_th
sunfast1038503sunfast_
sunfish1338883sunf_ish
uintaite8127353uintaite
unai44824783un_ai__
unais53420773un_ai_s
unakite1138743unakite
unapt710421593un_apt_
uncast84215713uncast_
uncouth1247173uncouth
unearths1144353unearths
unfaded123111733unfaded
unfading1347693unfading
unfairer11184283unfairer
unfairly1443563unfairly
unfaithful1951463unfaithful
unfaked153211173unfaked
unfancy1545203unfancy
unfasten1144843unfasten
unfazed20299053unfazed
unfelt92413463unfelt_
unfitly1335573unf_itly
unfix15429033unf_i_x
unfixt16398423unf_ixt
unhair937333unhai_r
unhairs1036373unhairs
unhasty1344283unhasty
unhat81119263unha_t_
unhats91110623unha_ts
unhitch1543053un_hitch
unit45140073un__it_
unite54828383un__ite
units54923433un__its
unity84918493un__ity
unknit1068593unknit_
unknits1135553unknits
unlaid7311753unlai_d
unlash938793unla_sh
unlatch1245053unlatch
unlit55025463un_lit_
unnail6410583unnai_l
unnails738223unnails
unpaid939473unpai_d
unplait948603unplait_
unplaits1044813unplaits
unsaid7411833unsai_d
unstitch1343593unstitch
untruth1045353untruth
unwhite1336813unwhite
unwish1239093un_wish
unwit84417523un_wit_
unwits9389893un_wits
urolith1048783urolith
wraith1258603_wraith

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.313570897.8
2DLD Change Limit134027776.54620474.6
3Display Results77770.0164812.5
 (SQL Overall)178691776.87525991.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.