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

50 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
willowier156378(None) 
billowier1444291billowier
willower14127451willow_er
wallower14158932wallow_er
willowed15156762willow_ed
willowers15166692willow_ers
willowiest1643232willowiest
willowing1645322willowing
willpower1773182willpow_er
bellower13159063bellow_er
billowed14137063billow_ed
billowiest1543633billowiest
billowing1545873billowing
blowier1248943__blowier
callower13159073callow_er
follower14137073follow_er
hallower14139813hallow_er
hillier103413963hill__ier
hollower14127393hollow_er
mellower13167403mellow_er
millier93716703mill__ier
pilloried1265313pilloried
pillories1189573pillories
pillowed14156383pillow_ed
pillowing1545493pillowing
sallower11139503sallow_er
sillier74017593sill__ier
swallower1554333swallow_er
walloper13147113wallo_per
wallowed15148163wallow_ed
wallowers15127653wallow_ers
wallowing1666073wallowing
widower1435343wi_dow_er
wieldier1234283wiel_dier
wildflower20112743wildflow_er
wildfowler2081593wildfowler
wilier93217073wi_l__ier
willer94021063will___er
willie94116453will__ie_
willied114611563will__ied
willies103920153will__ies
willinger1343723willinger
willow12369693willow___
willowlike2051333willowlike
willows13299753willow__s
willowware1551543willowware
willowy16276353willow__y
willpowers1842893willpow_ers
winnower1444253winnow_er
yellower14186213yellow_er

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 Filter1786911486410.423422437.4
2DLD Change Limit148641507.23320550.4
3Display Results50500.0331515.2
 (SQL Overall)178691507.68923239.8
 
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.