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

95 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
widens10621272(None) 
widen94717971widen_
wides94832821wide_s
wizens186110261wizens
aiders74524632aiders
aides65336602aide_s
biders94822802biders
bides85536772bide_s
bidets95215532bidets
ciders94620092ciders
codens94821012codens
dens55945072__dens
dizens164911392dizens
eiders74321362eiders
givens10379732givens
hiders104919652hiders
hides95129422hide_s
hoidens11329082hoidens
ideas65919012_ideas
ides57734232_ide_s
ladens74516232ladens
liens56525502li_ens
likens105613702likens
limens84618032limens
lindens839412lindens
linens64818392linens
livens94314892livens
lodens74315062lodens
maidens10349662maidens
middens11379382middens
miens76118302mi_ens
mildens10339932mildens
mizens174610252mizens
nides65229132nide_s
rewidens1235532rewidens
rident7520192rident
riders74123902riders
rides66140812ride_s
ripens85012172ripens
sides65838362side_s
sirens65318152sirens
swiddens1342712swiddens
tides64830152tide_s
videos104911372videos
vixens16286202vixens
waders109120642waders
wades95634142wade_s
wakens135012042wakens
wardens113711902wardens
wedelns11325242wedelns
wedels103811032wedels
weens85224052w_eens
wens76337932w__ens
wheens124610612wheens
whens114618762w_hens
whitens13428732whitens
widders123512272widders
wide85235412wide__
widely133311032widely
widened12328052widened
widener11318692widener
wideners12257992wideners
wideness12259472wideness
wider94826352wide_r
widest104517002widest
widgeons1343852widgeons
widgets12318452widgets
widows1376562widows
widths1335122widths
wifes114522562wife_s
wifeys15425872wifeys
wigans104511702wigans
wigeons1136982wigeons
wilders113513502wilders
wiles85437872wile_s
winders113721262winders
wines85546862wine_s
wins75949172wi__ns
wipers115416082wipers
wipes104827082wipe_s
wirers94617892wirers
wires86034912wire_s
wisent93516342wisent
wisents10249062wisents
wises85633192wise_s
witans93412932witans
wites85536962wite_s
wiverns13366962wiverns
wivers125320802wivers
wives115328922wive_s
wizen175813862wizen_
wizes174723342wize_s
wizzens18385482wizzens
wovens12449832wovens
wrens85016242w_rens

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit82551952.12338884.1
3Display Results95950.0332878.8
 (SQL Overall)178691952.51671021.9
 
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.