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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
mildewy1635353(None) 
mildew12319041mildew_
mildews13365881mildews
milded104416152milde_d
milden94113152milde_n
mildens10339932mildens
milder93818452milde_r
mildest102812062mildest
mildewed1543762mildewed
mildly12318242mild_ly
billowy15366903billowy
bindery13459833bindery
cindery13429193cindery
dewy115419023___dewy
gilded94413223gilde_d
gilder84415533gilde_r
gilders94212463gilders
meadowy1644043meadowy
medley1298343medle_y
melded104714713melde_d
melder93915813melde_r
melders103213913melders
mickey174211853micke_y
midday13327503mi_dday
midden104112853midde_n
middens11379383middens
middy124812593mi_d_dy
midleg1038553midle_g
midlegs1156323midlegs
midway15327153mi_dway
milady1236613mil_ady
mild75330853mild___
mildened1235773mildened
mildewing1643733mildewing
milding113615453milding
mildness1136523mildness
milds86422053mild__s
mile66352573mil_e__
miler75733063mil_e_r
milers84625163mil_ers
miles74645073mil_e_s
miliary1249463miliary
milieu8314113milie_u
milieus939803milieus
milieux1643783milieux
milked134612573milke_d
milker124814323milke_r
milkers134411613milkers
milkily16216553milkily
milky144014443mil__ky
mille75029133mille__
milled94326173mille_d
miller84625413mille_r
millers93621343millers
milles84526563mille_s
millet84030743mille_t
millets94216843millets
milneb1095953milne_b
milnebs11113793milnebs
milreis937323milreis
milted93919943milte_d
milter84921233milte_r
milters93619093milters
milty104720073mil__ty
minded103817833minde_d
minder94822503minde_r
minders103720123minders
misdeal1037663misdeal
misdeed113211053misdeed
misdeem12217873misdeem
misdrew1335833misdrew_
misery114113543mi_sery
misrely12319613misrely
mixedly2033983mixedly
molded104414083molde_d
molder93819273molde_r
molders103315553molders
moldy115014653mold__y
muley104819283mul_e_y
mulley114013453mulle_y
pillowy15316423pillowy
ridley10169543ridle_y
riley84420583ril_e_y
sideway1445673si_deway
silvery13328093silvery
sinewy12667513si_newy
slideway1543163slideway
smiley114012303smil_e_y
tideway1445153ti_deway
tilde65017343tilde__
tildes74513963tilde_s
tindery11389363tindery
viewy14518103vi__ewy
vilely1239443vil_ely
widely133311033wi_dely
wilded113714503wilde_d
wilder103616473wilde_r
wilders113513503wilders
wildest113311273wildest
wildly13328123wild_ly
willowy16276353willowy
windowy1744643windowy

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.406440125.6
2DLD Change Limit1340271025.70323501.1
3Display Results1021020.0303400.0
 (SQL Overall)1786911026.13929107.5
 
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.