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

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

103 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
blunts8451289(None) 
bluets87215491bluets
blunt75525021blunt_
blurts84412641blurts
brunts85215451brunts
bunts75729801b_unts
lunts55826901_lunts
abluents1045462abluents
alants67722022alants
aunts55227632_aunts
bents76033692b_ents
bhuts105812952bhu_ts
bints76130182b_ints
bionts8612392bionts
blanks124112892blanks
blasts85116772blasts
blats75132502bl_ats
bleats85518612bleats
blends96012882blends
blent76230952blent_
blets75324942bl_ets
blinds95111612blinds
blinis85313682blinis
blinks124613572blinks
blintz1788842blintz
bloats85215762bloats
blonds95213342blonds
blots75626172bl_ots
blubs95818152blu_bs
blues75127042blu_es
bluest84016482bluest
bluet75631192bluet_
blueys11419522blueys
bluffs14388372bluffs
bluings10327962bluings
blumes105917792blumes
blunge94311482blunge
blunges104212222blunges
blunted104210662blunted
blunter94512032blunter
bluntest1036552bluntest
bluntly1235222bluntly
blurbs10489312blurbs
blurs74619082blu_rs
blurt77625622blurt_
bounds94415802bounds
bounty113411072bounty
bouts75131312bou_ts
brants85723052brants
brents84717272brents
bruits85714452bruits
brunets9419552brunets
brunt75728752brunt_
bruts75922952bru_ts
bunas75126572b_unas
bunds85523542b_unds
bundts95010842b_undts
bungs85323862b_ungs
bunks115125082b_unks
bunns74718292b_unns
buns66243722b_un_s
bunt65850852b_unt_
busts75227692b_usts
buts67247692b_u_ts
butts75824252b_utts
clunks124811012clunks
counts84618272counts
cunts76125122_cunts
daunts75014082daunts
dunts65828412_dunts
elints65816422elints
eluants737582eluants
eluents738702eluents
flaunts1056132flaunts
flints95617452flints
flunks13469862flunks
fluyts12367152fluyts
founts94313382founts
glints75714212glints
gluts66120132glu_ts
grunts75511852grunts
haunts95614392haunts
hunts86826172_hunts
jaunts137511882jaunts
lints57137192_lints
lunas55025012_lunas
lunes55337772_lunes
lunets66914762_lunets
lungs65223882_lungs
lunks94822452_lunks
lunt46148842_lunt_
lusts55022802_lusts
mounts84115072mounts
plants84921802plants
plunks124711162plunks
punts75828002_punts
runts55927632_runts
shunts95712012shunts
slants64819082slants
sluts54523982slu_ts
stunts65615252stunts
taunts65715662taunts
vaunts95212622vaunts

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 Filter178691825510.296603685.8
2DLD Change Limit825511035.67314551.6
3Display Results1031030.0631634.9
 (SQL Overall)1786911036.03229623.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.