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

99 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
hoopsters144569(None) 
hoopster1335541hoopster_
boosters104013442boo_sters
doomsters1236172doomsters
hipsters13268792h_ipsters
hoisters113513482h_oisters
holsters113211942h_olsters
hoopers123616482hoop__ers
hooters104520472hoo__ters
roosters83514662roo_sters
adopters1136693adop_ters
boasters103915663_boasters
bolsters103712453_bolsters
booster94314553boo_ster_
choosers134810873choo_s_ers
choristers1586103choristers
cloisters1137433cloisters
coasters104317333_coasters
composters16388323composters
computers15339753computers
coopers114019483coop__ers
cooters94525723coo__ters
copters113621283_cop_ters
costers94128333_co_sters
dempsters1435273dempsters
diopters1137693diop_ters
doomster1135843doomster_
doorsteps1252553doorsteps
dopesters1237283dopesters
dumpsters1453743dumpsters
footers104618333foo__ters
footsteps1462863footsteps
foresters12312533foresters
fosters104220103_fo_sters
gypsters1434023_gypsters
hamsters13710423h_amsters
heisters113413133h_eisters
hipster12288783h_ipster_
hoister103714203h_oister_
holster103512213h_olster_
honester1139713honester_
hoofers134513323hoo__fers
hookers144916513hoo__kers
hooper114518313hoop__er_
hoopless13279263hoop_less
hoopoes121212483hoop_oe_s
hoopskirt1852133hoopskirt
hoopskirts195793hoopskirts
hooter94123933hoo__ter_
hoovers134312703hoo__vers
hopers114222973h_op__ers
hoppers143115143h_op_pers
horstes104516113h_orste_s
hosers95223963h_o_s_ers
hosiers104212643h_o_siers
hostels103712313h_o_stels
hostess103210243h_o_stess
hostlers113310483h_o_stlers
housers104717813h_ous_ers
hucksters1843653hucksters
imposters13347343imposters
jokesters2044443jokesters
jousters153210423_jousters
lobsters10268743_lobsters
loopers93914033loop__ers
looters74419163loo__ters
mobsters12359063_mobsters
molesters1198873molesters
monoesters1245993monoesters
monsters103314553_monsters
mooters93818623moo__ters
noosers74913923noo_s_ers
oldsters996733_oldsters
ousters74122793__ousters
oysters103411693__oysters
pollsters1137173pollsters
poofters1336923poo_fters
posters93928013_po_sters
quipsters2043593quipsters
roadsters1035103roadsters
roasters83615933_roasters
roisters83615553_roisters
roosers74217873roo_s_ers
rooster74415173roo_ster_
rooters74522933roo__ters
rosters73727543_ro_sters
rousters84315683_rousters
roysters113610533_roysters
shooters112811583shoo__ters
songsters1046113songsters
tapsters10318803_tapsters
throwsters1642713throwsters
tipsters10278513_tipsters
toasters83912723_toasters
tooters73818773too__ters
whoopers16286263whoop__ers
woopses1237883woops_e_s
zoolaters1844983zoolaters
zosters163015413_zo_sters

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.440406115.9
2DLD Change Limit148641997.28020417.7
3Display Results99990.0303300.0
 (SQL Overall)178691997.75023056.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.