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

159 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
wildish144685(None) 
widish13419361wi_dish
baldish1339502baldish
childish1744392childish
coldish1399302coldish
kiddish16276582kiddish
oldish10169312_oldish
wildest113311272wildest
wilding123814292wilding
wilds94818202wild_s_
wimpish1765682wimpish
winish124212262wi_nish
wispish1575642wispish
wolfish1636932wolfish
bidis86721143bi_dis_
biggish14247503biggish
billfish1645033billfish
bindis94614583bindis_
bluish1159243_bluish
bullish12511193bullish
caddish143810123caddish
coltish121310933coltish
cultish12139113cultish
delish105215613del_ish
dildos8179303dildos_
dish86328333___dish
dollish11610093dollish
doltish11118733doltish
dudish1148313_dudish
dullish1148743dullish
elfish1267963_elfish
elvish1277563_elvish
faddish15359003faddish
fiendish1544033fiendish
filefish1745593filefish
filmis114610283filmis_
finfish16268193finfish
finish124613403fi_nish
fluish1239333_fluish
folkish1736563folkish
gilding103813003gilding
gilds75417523gild_s_
girlish1137193girlish
goldfish1644203goldfish
goodish1237963goodish
hellish13310723hellish
hickish1936473hickish
hilding123713533hilding
hippish1736183hippish
impish13499173_impish
iodise74214933_iodise
iodism93611123_iodism
jadish17319903_jadish
jiggish19225943jiggish
kaddish16317973kaddish
kiddush16242483kiddush
laddish12299723laddish
loudish1137983loudish
maddish14289483maddish
maidish13239553maidish
midis85923403mi_dis_
midlist10312513midlist
miladis1049813miladis_
mildest102812063mildest
milding113615453milding
milds86422053mild_s_
milkfish2043333milkfish
minish115216293mi_nish
minxish1936213minxish
modish123813543_modish
mulish11311903mul_ish
nerdish1137103nerdish
oddish11107653_oddish
owlish1238693owl_ish
palish114718273pal_ish
pigfish16217173pigfish
piggish14227703piggish
pilis75825203pil_is_
pinfish15319303pinfish
pinkish16279113pinkish
pixyish2253653pixyish
polish114916723pol_ish
prudish1376563prudish
radish103516913_radish
reddish1238033reddish
relish93916953rel_ish
sailfish1446053sailfish
saltish10312163saltish
selfish1388513selfish
sickish1638423sickish
silds65520523sild_s_
swinish1347203swi_nish
tallish103313583tallish
tigrish1137563tigrish
tildes74513963tildes_
tilefish1445453tilefish
toadish1139063toadish
tundish1137283tundish
wadis95223963w_adis_
waggish15207073waggish
waifish1637703waifish
wampish1777293wampish
warmish1538373warmish
waspish1586923waspish
weakish17217173weakish
wearish132310153wearish
welding123213253welding
welds94719163weld_s_
welsh113110363wel__sh
wennish1336243wennish
wettish1335963wettish
wheyish1944063wheyish
whish144512923w__hish
whitish1635973whitish
whorish1636603whorish
widdie113410733widdi_e
widdies123514033widdies
wides94832823wi_des_
widest104517003wi_dest
width12310963wi_d_th
widths1335123wi_dths
wieldier1234283wieldier
wieldiest1334803wieldiest
wielding13286863wielding
wields10469623wield_s_
wild85126513wild___
wildcat1346293wildcat
wilded113714503wild_ed
wilder103616473wild_er
wilders113513503wilders
wildfire1542803wildfire
wildings13287923wildings
wildlife1543253wildlife
wildling13248083wildling
wildly13328123wild_ly
wildness1236203wildness
wiles85437873wil_es_
wilier93217073wil_ier
wiliest103416593wiliest
wilily123310763wil_ily
wiling103024293wil_ing
willie94116453willi_e
willied114611563willied
willies103920153willies
willing113821613willing
wills84528963wil_ls_
wilting113515913wilting
wilts85023503wil_ts_
windier113412163windier
windiest122213233windiest
windigo12415953windigo
windily1437943windily
winding123517913winding
winds95425603wind_s_
wish107228733w___ish
woggish15276673woggish
wolds95420183wold_s_
wolffish2043333wolffish
wormish1537163wormish

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.1561145455.1
2DLD Change Limit1340271597.68617437.8
3Display Results1591590.0632523.8
 (SQL Overall)1786911597.90522604.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.