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

94 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
swith11591740(None) 
saith85826551saith
sith75435151s_ith
smith107818041smith
swath115920381swath
swish115114821swish
switch14458911switch
swithe124010681swithe
with105730471_with
baith108023132baith
brith104924372brith
faith115620852faith
frith115922032frith
grith95520372grith
kith115826352_kith
laith85722102laith
pith95432692_pith
saithe94713912saithe
shit76745932shit_
shits84731162shits
sidh86222982s_idh
sigh85625892s_igh
sinh76238042s_inh
sit35877752s_it_
site47052412s_ite
sits45050202s_its
sixth155512232sixth
skit85437522skit_
skite95120042skite
skits94721852skits
slit46250102slit_
slits56128852slits
sloth85019442sloth
smit65138402smit_
smite75224862smite
smiths114711022smiths
smithy14508272smithy
snath86419802snath
snit46342472snit_
snitch11357942snitch
snits54124832snits
sooth85924052sooth
soth75932512s_oth
south85223572south
spilth11469732spilth
spit65545082spit_
spite75430662spite
spits74429552spits
spitz166017962spitz
stich104117922stich
stitch11419102stitch
stithy12398212stithy
suit45649872suit_
suite54829562suite
suits55028052suits
swarth126012082swarth
swash116316752swash
swat77244442swat_
swatch14549282swatch
swathe125514112swathe
swaths125312642swaths
swats85726862swats
swift116818052swift
swifts12408172swifts
swig85818022swi_g
swigs96213662swigs
swill83417372swill
swim96221392swi_m
swims105514142swims
swine85625302swine
swing96124842swing
swink125116352swink
swipe105217082swipe
swirl84514142swirl
swishy15365842swishy
swiss86712902swiss
swither133710992swither
swithly1634442swithly
swive115316192swive
swot75134652swot_
swots85518422swots
synth113711822synth
twit76329062twit_
twitch14406162twitch
twits86015792twits
wich125724742_wich
width12310962_width
wish107228732_wish
wit66563772_wit_
witch134517562_witch
wite75443272_wite
withe115220232_withe
withy144813762_withy
wits76044872_wits

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.0931921408.6
2DLD Change Limit53800942.09325704.7
3Display Results94940.0462043.5
 (SQL Overall)178691942.23280058.7
 
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.