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

102 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
gazumps213187(None) 
gazump2032451gazump_
galumph15102662galumph
galumphs1642022galumphs
gamps105323712ga__mps
gaums86217072ga_um_s
gazumped2341402gazumped
gazumper2241462gazumper
gazumpers2341422gazumpers
grumps114510572g_rumps
mazumas2034622mazumas
abamps1236253_abamps
alums75720603_alum_s
amps86230343_a__mps
arums75517833_arum_s
azukis1963733_azukis
azures15510183_azures
bumps115921143__bumps
camps116330263ca__mps
chumps154313823_chumps
clumps1215314643_clumps
crumps124514343_crumps
damps105220413da__mps
datums936353datum_s
dumps105220103__dumps
fanums1137263fanum_s
flumps135112503_flumps
frumps13479783_frumps
gallops103211653gallops
galops94712613ga_lops
gamas85431353ga__mas
gambs105721123ga__mbs
games86238553ga__mes
gammas115714693ga_mmas
gamp98833213ga__mp_
gams76648883ga__m_s
gamuts958783gamu_ts
gaps76042973ga___ps
gasps85415483ga__sps
gauds75717723ga_u_ds
gauges85915993ga_uges
gaults74112783ga_ults
gaum75726423ga_um__
gaumed104610323ga_umed
gaurs66317993ga_u_rs
gauss65613453ga_u_ss
gauzes164710633ga_uzes
gawps115911013ga__wps
gazabos1944453gazabos
gazars164811553gaz_ars
gazebos1933493gazebos
gazers164516293gaz_ers
gazes155425913gaz__es
gazoos163010223gaz_oos
gazumping2441443gazumping
getups9346853getu_ps
geums85414113g_eum_s
gimps105915203g__imps
gizmos1844133giz_mos
glumes94516813g_lumes
glumpy14527193g_lumpy
glums84621423g_lum_s
gramps114114273g_ramps
groups94210513grou_ps
grumes94415553g_rumes
grump105115313g_rump_
grumpy14498153g_rumpy
gulps84715073g__ulps
gums75030943g__um_s
harumph1742933harumph
harumphs1841923harumphs
humps126322803__humps
jaups144810533ja_u_ps
jumps165116493__jumps
lamps95624833la__mps
larums83610533larum_s
layups1133993layu_ps
lazulis1634903lazulis
lumps95624983__lumps
mazuma1935603mazum_a
metumps1334133metumps
mumps115619103__mumps
oakums1264153oakum_s
plumps124612613_plumps
pumps115520603__pumps
ramps96224633ra__mps
repumps1334403repumps
rumps95922293__rumps
samps96124673sa__mps
shlumps1434143shlumps
slumps104313583_slumps
stumps104912283_stumps
sumps95023433__sumps
tamps95524083ta__mps
thumps13449353_thumps
trumps104611883_trumps
tumps95420793__tumps
umps85721943___umps
vamps125415483va__mps
warmups1433813warmups
whumps16427093_whumps
yaups105910743ya_u_ps

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340271029.30014411.5
3Display Results1021020.0303400.0
 (SQL Overall)1786911029.48318843.3
 
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.