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

51 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
spavin11421065(None) 
pavin105623201_pavin
savin84625081s_avin
spavie113611381spavie
spavins12419321spavins
flavin1239302flavin
mavin105722952_mavin
pain65647242_pa_in
patin76832852_patin
pavan106518472_pavan
pavid115717002_pavid
paving124519742_paving
pavins114919662_pavins
pavis106422732_pavis
ravin85624652_ravin
sabin74924952s_abin
sain45551292s_a_in
sarin55239252s_arin
sasin54626572s_asin
satin55935222s_atin
savine94220282s_avine
saving104724512s_aving
savins93923132s_avins
shaven124213302shaven
shavie124312422shavie
shaving143414332shaving
slain54923572sla_in
slaving113514832slaving
spacing123614492spacing
spading113114382spading
spadix1636112spadix
spaeing103413542spaeing
spahi10311142spahi_
spahis11310382spahis
spail74921552spa_il
spait75631602spa_it
span65234662spa__n
sparid94016932sparid
sparing104823872sparing
spavies123012942spavies
spaviet123011922spaviet
spavined1434332spavined
spawn107811712spa_wn
spaying133014622spaying
spin66231302sp__in
sprain83614862sprain
stain55727942sta_in
statin63921472statin
staving113915702staving
swain84919052swa_in
sylvin12247302sylvin

Search took 4 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 Filter178691825510.376475242.0
2DLD Change Limit82551512.76329877.3
3Display Results51510.0163187.5
 (SQL Overall)178691513.15556637.4
 
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.