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

116 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
gruellers103418(None) 
gruelers936171grue_lers
grueller935331grueller_
crueller1056452crueller_
crullers1047302cru_llers
duellers9268222_duellers
fuellers11277982_fuellers
grillers93810812gr_illers
grovellers1443322grovellers
grueler837022grue_ler_
gruelled1034892gruelle_d
grumblers14245022grumblers
krullers1234132kru_llers
quellers17237532_quellers
bevellers14276143bevellers
braillers1135553braillers
crueler939023crue_ler_
cruellest1155583cruellest
cruelness1145053cruelness
cruller968753cru_ller_
cullers93418853_cu_llers
cupellers1374863cupellers
drillers9429723dr_illers
drivellers1452953drivellers
duelers83412053_due_lers
dueller8329833_dueller_
dwellers12356083_dwellers
expellers18104753expellers
fellers104117543__fellers
frillers11349873fr_illers
fuelers103912393_fue_lers
fueller10279963_fueller_
fullers103817373_fu_llers
gabelles11278933gabelle_s
gaseliers1044923gaseliers
gazelles18266563gazelle_s
gelders93812573g__elders
gillers84216903g__illers
gospellers1363023gospellers
grabblers14345513grabblers
grapplers14274303grapplers
greasers93410253gr_easers
greedless1144893greedless
greenlets1044703greenlets
greeters92610113gr_eeters
grievers1255473grie_vers
griller84513353gr_iller_
grillery12355503gr_illery
grilles83715023gr_ille_s
grizzlers18253233grizzlers
grovelers13305163grovelers
groveller1354233groveller_
growlers12327093gr_owlers
grubbers13316203gru_bbers
grudgers11266753gru_dgers
grueled937133grue_le_d
gruelings1163763gruelings
gruelling1155603gruelling
gruellings1272323gruellings
gruels73910153grue_l__s
grumbler13866683grumbler_
grumbles13288873grumble_s
grungers10298503gru_ngers
grunters9359033gru_nters
gruntles9287233gruntle_s
guessers9174903g_uessers
guilders1035513g_uilders
gullets84013713g_u_llets
gulleys11438523g_u_lleys
gulpers10299013g_u_lpers
guttlers9306933g_uttlers
guzzlers17274863g_uzzlers
hellers103619833__hellers
hullers103616263_hu_llers
impellers1345103impellers
jewellers1943543jewellers
kruller1145153kru_ller_
labellers11206553labellers
levellers12286053levellers
libellers11236033libellers
lullers73213353_lu_llers
marcellers1443833marcellers
modellers1245393modellers
mullers93217303_mu_llers
propellers1455203propellers
prunelles1145063prunelle_s
pullers93618483_pu_llers
queller16289293_queller_
ravellers12257163ravellers
reelers73520273_r_eelers
reliers75519213_r_eliers
repellers11278883repellers
resellers9299933resellers
revellers12319513revellers
rollers73117473_r_ollers
rufflers14347193_rufflers
ruleless836633_ruleless
rulers64317093_ru__lers
rumblers123610743_rumblers
rustlers8339853_rustlers
scullers103510483scu_llers
sellers73721323__sellers
shellers112812583_shellers
smellers10329773_smellers
spellers102812763_spellers
squallers1834683squallers
squealers1894453squealers
tellers73717603__tellers
travellers1364663travellers
trillers83613493tr_illers
trollers83211213tr_ollers
trowellers1343663trowellers
trucklers15295583trucklers
trundlers10215003trundlers
yellers103912953__yellers
yodellers1343973yodellers

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411166.50022867.8
3Display Results1161160.0462521.7
 (SQL Overall)1786911166.96925640.8
 
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.