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

85 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
tawdrier1213343(None) 
tawdries12136081tawdries
bawdier13378202bawd_ier
bawdries14136842bawdries
tardier859719992tard_ier
tarrier74323172ta_rrier
tawdriest13143292tawdriest
tawdrily1542732tawdrily
tawnier10318462taw_nier
towerier1137122towerier
aerier64823153_a_erier
airier64619363_a_irier
angrier839023_angrier
awarder1135893_awarder
barrier94017733ba_rrier
bawdies134613393bawd_ies
bawdric15164583bawdri_c
bawdrics16153273bawdrics
cabdriver1741673cabdriver
carrier93619583ca_rrier
catbrier1236173catbrier
dandier93714573dand_ier
dawdler12356793dawd_ler
dowdier12328573dowd_ier
drier64423963___drier
faddier1237783fa_ddier
farrier103514893fa_rrier
fawnier13296363faw_nier
gaudier938453gaud_ier
gawkier15326523gaw_kier
hairier103111053ha_irier
handier113817443hand_ier
hardier114721543hard_ier
harrier104417753ha_rrier
lardier83518343lard_ier
marrier93817523ma_rrier
paltrier1037533paltrier
parrier93717653pa_rrier
pawkier16236613paw_kier
randier83618473rand_ier
rowdier11348593rowd_ier
sandier84017843sand_ier
savorier1136643savorier
starrier8279463sta_rrier
taborer9269293tabor_er
tackier133712523ta_ckier
talkier114011843ta_lkier
tallier72817213ta_llier
tangier83013913ta_ngier
tanglier948073tanglier
taperer92511793taper_er
tardies84225863tard_ies
tarried83914133ta_rried
tarriers83411713ta_rriers
tarries73324263ta_rries
tarsier74119253ta_rsier
tarter64023563ta__rter
tartier74123263ta_rtier
tastier711817093ta_stier
tattier74216243ta_ttier
taverner1134423taverner
tawdriness1482843tawdriness
tawdry13395253tawdr__y
tawer85223443taw___er
tawie84819813taw__ie_
tawnies102812503taw_nies
tawpie11339143taw_pie_
tawpies12309873taw_pies
tearier73815613t_earier
terrier73414963t_errier
thwarter1433393thwarter
tidier73515113t_id_ier
trier54328533t___rier
twaddler13314643twaddler
twangier1254243twangier
twier84713293t_w__ier
twinier1037313t_winier
twirler10285203t_wirler
twirlier1133513t_wirlier
unwarier1136883unwarier
varier94619353va__rier
warier93722893__warier
waterier11312083waterier
wirier94215553__wirier
wrier84521753__w_rier

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit146162857.97018339.0
3Display Results85850.0332575.8
 (SQL Overall)178691858.42321214.7
 
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.