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 “sandpit” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
sandpit104963(None) 
sandpits1146841sandpits
bandit93821132band_it
pandit93820752pand_it
sandhi1038192sandhi_
sandhis1139992sandhis
sandlot8311692sandlot
sandpile1146772sandpile
standpat1145722standpat
adit56443653_a_d_it
admit8319493_a_dmit
anopia83412393_anopia
armpit10811093_armpit
audit62527883_aud_it
bandaid11310483bandaid
bandito103710043band_ito
bandits103814793band_its
bankit123617043ban_kit
candent10417363candent
candid104517853cand_id
canopic1338803canopic
conduit10713083conduit
handlist12311333handlist
handout11314103handout
handpick2043843handpick
handprint1546983handprint
handset113016823handset
handwrit1547243handwrit
mandril1049353mandril
manumit1149573manumit
nandin7313033nand_in
pandect12310953pandect
pandits103914213pand_its
pundit92914183pund_it
saddest92412383saddest
sadi55834643sa_d_i_
sadis64930853sa_d_is
sadist74221353sa_dist
salpid9510883sa_lpid
sanctity1345593sanctity
sand55338473sand___
sandal73317283sand_al
sandals82715203sandals
sandbag11106243sandbag
sandbar10108193sandbar
sandbox1744803sandbox
sandbur10105353sandbur
sanddab1144923sanddab
sanded84920613sand_ed
sander74828533sand_er
sanders84025943sanders
sandfish1556683sandfish
sandfly1435643sandfly
sandhog1275453sandhog
sandier84017843sandier
sandiest93218693sandiest
sanding93520603sanding
sandlike1339713sandlike
sandling102214413sandling
sandlots938293sandlots
sandman10310173sandman
sandmen1039413sandmen
sandpeep1342963sandpeep
sandpiles1246303sandpiles
sandpiper14103523sandpiper
sands65228583sand__s
sandspur1142403sandspur
sandwich1743653sandwich
sandwort12410083sandwort
sandy94221133sand__y
sanest64426693san_est
sangria838113sangria
sanity9316203san__ity
sansei63411903sansei_
sanseis73011603sanseis
santir6315253san_tir
sapid84720933sa__pid
sawdust1154533sawdust
scandent1148493scandent
scandia1038063scand_ia
scandic1237003scand_ic
sennit63117923sen_nit
senopia949233senopia
shilpit1247103shilpit
sinopia947743sinopia
sinopie948783sinopie
skelpit1344943skelpit
snakepit1453963snakepit
snit46342473s_n__it
spandril1144093spandril
spit65545083s___pit
standout948663standout
standpipe1443343standpipe
standpoint1353513standpoint
sunlit61516103sun_lit
sunspot947163sunspot
sunsuit748693sunsuit
syndet10311963synd_et
syndic1237303synd_ic

Search took 9 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.436409841.7
2DLD Change Limit134027997.96616824.9
3Display Results99990.0333000.0
 (SQL Overall)178691998.43521184.5
 
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.