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

172 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
avoiders125478(None) 
avoider1155811avoider_
voiders11279821_voiders
abiders104011082a_biders
aiders74524632a__iders
avodires1244122avodires
avoided1235552avoide_d
avoids104410202avoid__s
avowers1336332avo_wers
broiders114211182broiders
voicers12348992_voicers
voider103611552_voider_
abider95314463a_bider_
abides94719893a_bide_s
abodes94417513abo_de_s
aboideau1142873aboideau
aboideaus1251773aboideaus
aborters1038563aborters
abraders1137343abraders
abridgers1343293abridgers
acceders1334793acceders
accorders14144113accorders
acrider1038623acrider_
adders84315703a__dders
admirers1134703admirers
adopters1136683adopters
adorers84411723ado_rers
adorners9196613adorners
advisers12135003advisers
affixers2143293affixers
aider65431133a__ider_
aides65336603a__ide_s
aimers84621913a__imers
airers64922313a__irers
aivers94822323a__ivers
alders74218423a__lders
aliners74717723a_liners
amenders11288343amenders
amides95722663a_mide_s
anodes74418753ano_de_s
anointers936993anointers
aphides134711203aphide_s
apsides103911303apside_s
aquifers2044393aquifers
arbiters1038853arbiters
arider74717743a_rider_
armigers1135703armigers
aroids75118223aroid__s
arousers84810973arousers
arrivers11137003arrivers
asides75118873a_side_s
aspirers1066493aspirers
atomisers11255453atomisers
atomizers20265553atomizers
atoners75013953ato_ners
avengers1235583avengers
avers85127313av___ers
averters11249503averters
avidins11349003av_idins
avidness1246113av_idness
avocets1235453avo_cets
avodire1143763avo_dire
avoid95516673avoid___
avoiding1336783avoiding
avosets1036663avo_sets
avouchers1743083avouchers
avower1236823avo_wer_
awaiters1146643awaiters
awarders1245073awarders
azides165113803a_zide_s
biders94822803__biders
boilers93417063_boilers
bonders104120663_bonders
borders104317533_borders
braiders114110573braiders
broider103912973broider_
broidery14356083broidery
broilers103210093broilers
brooders112610233brooders
cavilers1348113cav_ilers
cavorters1434963cavorters
chiders135312943_chiders
chowders17387533chowders
ciders94620083__ciders
clowders14357473clowders
codders114114443_codders
coders95426973_co_ders
coilers93619903_coilers
coiners93620753_coiners
corders104520873_corders
crowders14398793crowders
deciders123510753deciders
deriders102411853deriders
dividers13257213dividers
dodders105511793_dodders
eiders74321363__eiders
eloiners8128153eloiners
evaders1136933ev_aders
evokers14386793evo_kers
evolvers14264773evolvers
favorers1465493favo_rers
favourers1543123favourers
flooders12257833flooders
fodders124010753_fodders
folders113514393_folders
gliders94811843_gliders
goiters84014433_goiters
guiders94111103_guiders
hagriders1443553hagriders
havockers2142123havockers
hiders104919653__hiders
hoidens11329083_hoidens
holders113715903_holders
insiders947753insiders
joinders16337203_joinders
joiners144211573_joiners
lavenders1334753lavenders
loaders83413413_loaders
loiters74116613_loiters
moilers93615203_moilers
molders103315553_molders
nodders94410253_nodders
oilers64721193__oilers
orders74315993__orders
oroides8311973oroide_s
ovoidals1242493ovoidals
ovoids10456923ovoid__s
pavisers13387443pav_isers
plodders1235523plodders
poisers94214433_poisers
polders103617373_polders
ponders103618843_ponders
powders134111553_powders
prodders1237453prodders
providers1535583providers
raiders84615143_raiders
reorders9198833reorders
residers93311883residers
riders74123903__riders
savorers1157223savo_rers
savourers1243833savourers
scolders11288993scolders
scowders14276213scowders
sliders83515223_sliders
smolders11287193smolders
solders83517773_solders
sonders83820713_sonders
spiders103914413_spiders
spoilers10238633spoilers
striders94412123striders
toilers74116263_toilers
variers103712663vari_ers
veilers103911823_veilers
veiners104112523_veiners
venders113717003_venders
videos104911373_v_ideos
viers85621953_v_i_ers
vipers114914533_v_ipers
vivers124717363_v_ivers
vocoders1434243_vocoders
voguers11356683_voguers
voicer113910543_voicer_
voices114414013_voice_s
voided114011133_voide_d
voidness1235553_voidness
voids95414673_void__s
voiles94616443_voile_s
vomers115614943_vo_mers
vomiters1337203_vomiters
voters95017443_vo_ters
vowers124317183_vo_wers
wonders113315993_wonders

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621727.00020880.3
3Display Results1721720.0762263.2
 (SQL Overall)1786911727.23224708.4
 
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.