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

88 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
spitz16601797(None) 
spit65545081spit_
spite75430661spite
spits74429551spits
spritz174714421spritz
blitz165318132blitz
ditz146929512_ditz
fritz176020772fritz
glitz154916372glitz
pit56471922_pit_
pita65436432_pita
pith95432692_pith
pits66348742_pits
pity96031932_pity
putz158326322_putz
ritz135129982_ritz
saith85826552saith
shit76745942shit_
shits84731172shits
sit35877752s_it_
site47052412s_ite
sith75435152s_ith
sits45050202s_its
skit85437532skit_
skite95120052skite
skits94721862skits
slit46250102slit_
slits56128852slits
smit65138412smit_
smite75224872smite
smith107818052smith
snit46342472snit_
snits54124832snits
sopite84917712sopite
spait75631602spait_
spaits85017472spaits
spat66548522spat_
spate74731582spate
spats75031382spats
spaz155626162sp_az
spazz155811132spazz
speltz174010122speltz
spic85227432spi_c
spica94717942spica
spice95528812spice
spick134519072spick
spics94123242spics
spicy125417712spicy
spied85427712spied
spiel74623912spiel
spier75728032spier
spies76037622spies
spiff133616402spiff
spik105419712spi_k
spike114922842spike
spiks114117472spiks
spiky146014112spiky
spile75230082spile
spill74821162spill
spilt75532222spilt
spilth11469732spilth
spin66231302spi_n
spine76534422spine
spins75327982spins
spinto8410662spinto
spiny104921302spiny
spire75828692spire
spirt75032952spirt
spirts85317132spirts
spiry105017352spiry
spital83813872spital
spited94820442spited
spites84127332spites
spitzes1849182spitzes
spiv95917792spi_v
spivs105114242spivs
split75729012split_
splits85416412splits
spot65540692spot_
spots74424112spots
sprit76736402sprit_
sprite84421772sprite
sprits85122532sprits
sputa74612962sputa
suit45649872suit_
suite54829562suite
suits55028052suits
swith115917402swith

Search took 3 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 Filter178691538000.593301333.9
2DLD Change Limit53800881.61033416.1
3Display Results88880.0302933.3
 (SQL Overall)178691882.23380022.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.