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

111 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
weensier113424(None) 
teensier835571teensier
weenier103210801ween_ier
teenier72611142teen_ier
teentsier942412teentsier
weedier113810622wee_dier
weenie92612022ween_ie_
weenies102915092ween_ies
weensiest1244742weensiest
weepier12319272wee_pier
wennier10318602w_ennier
beechier1535633beechier
beefier12329093bee_fier
beerier93613023bee_rier
bendier103111413_bendier
censer84516583_cens_er
cheesier1335963cheesier
creasier103210193creasier
deedier93011593dee_dier
deemster1175713deemster
denier74420693_den_ier
denser74115193_dens_er
dernier83011943dern_ier
dressier956863dressier
dweebier1442223dwee_bier
easier64218463__easier
eelier64216463_ee_lier
eerier64320023_ee_rier
envier939673__envier
fennier10339253_fennier
fernier103110823fern_ier
flenser1036783flens_er
geekier12286393gee_kier
greasier9298083greasier
greenier938713green_ier
keener104012833keen__er
keester11319913kee_ster
leerier73111503lee_rier
messier93412923_messier
muenster1043313muenster
needier84010623nee_dier
newsier10147223_newsier
penster92811953_penster
queasier1734473queasier
queenlier1842123queenlier
reechier1336673reechier
reedier83815303ree_dier
reefier102912553ree_fier
reekier113111123ree_kier
reenter73217793reen_ter
rentier73618223_rentier
seedier83513633see_dier
seemlier1035193seemlier
seepier92912013see_pier
sheenier11167423sheen_ier
sonsier7711743_sonsier
spendier1147143spendier
sweenies11148763sween_ies
sweepier1355493swee_pier
teenager9115293teenager
teener64717503teen__er
teensiest945823teensiest
tenser64919433_tens_er
tentier73815923_tentier
trendier937913trendier
tressier847963tressier
tweedier1253623twee_dier
tweener10306833tween__er
tweenies11146393tween_ies
uneasier836963uneasier
veinier10269583vein_ier
vernier102711273vern_ier
wanier93920683w_an_ier
weaklier1534263weaklier
weaner93816773wean__er
wearier103613283w_earier
webbier1445423w_ebbier
webster1236093w_ebster
wedgier12428273w_edgier
weeder103315513wee__der
weeklies1534913weeklies
weened104013733ween__ed
weeniest112411213ween_iest
weening114113973ween_ing
weens85224053weens___
weensy12416823weens__y
weeper114313303wee__per
weepie11258793wee_pie_
weepies122811743wee_pies
weever123811443wee__ver
weiner94214133wein__er
welsher13377443w_elsher
wencher153811133w_encher
wester94222893w_e_ster
wheezier2333343wheezier
whelkier1833253whelkier
whenever1742773whenever
whinier134110633whin_ier
whinnier14255003whinnier
wieldier1234283wieldier
wiener94513543wien__er
wienie9229973wien_ie_
wienies102213683wien_ies
windier113412163w_indier
wingier113413283w_ingier
winier94522453w_in_ier
wonkier1437423w_onkier
woodsier1245473woodsier
wrencher16287783wrencher
wrester102812413wre_ster
wussier10408083w_ussier

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621116.34323043.0
3Display Results1111110.0333363.6
 (SQL Overall)1786911116.53227356.2
 
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.