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

73 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
ulsters7271198(None) 
lusters73921441lusters
ulster63712101ulster_
alters64924222al_ters
asters65631602_asters
basters94930312basters
bisters93922612bisters
blasters104116142blasters
blisters104015082blisters
blusters104413892blusters
bolsters103712452bolsters
bursters1038982bursters
busters94724132busters
casters94729902casters
clusters102912402clusters
clysters13227842clysters
costers94128342costers
dusters84918362dusters
easters75125682easters
elaters74420192elaters
esters64627732_esters
festers104121392festers
flusters113811502flusters
fluters103713682fluters
fosters104220102fosters
gasters85624292gasters
glisters93912602glisters
holsters113211942holsters
jesters144118192jesters
justers143815732justers
klisters123910482klisters
lasters75627692lasters
listers74026532listers
liters65429882_liters
luster64023672luster_
lustres73013232lustres
masters94628922masters
misters93927512misters
munsters104010552munsters
musters94522512musters
nesters74422792nesters
oldsters996732oldsters
ousters74122792ousters
oysters103411692oysters
pasters94531732pasters
pesters93827092pesters
plasters103518132plasters
platers93924092platers
posters93928012posters
pulsers94213152puls_ers
punsters103310582punsters
questers17168762questers
rasters74629022rasters
resters74130402resters
rosters73727552rosters
sisters73721592sisters
slaters73123732slaters
tasters74225642tasters
testers74124542testers
ulcers839382ul_cers
uniters73814172uniters
unsteps936212unsteps
upsteps1133742upsteps
upstirs935292upstirs
ureters7311822ureters
users55817572u_s_ers
ushers94415532u_shers
utters63817122u_tters
wasters104026592wasters
westers105221962westers
xysters17307162xysters
zesters163517292zesters
zosters163015412zosters

Search took 10 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 Filter1786911076710.890200776.4
2DLD Change Limit107671737.73613918.2
3Display Results73730.0601216.7
 (SQL Overall)178691738.68620572.3
 
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.