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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

136 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
swives12391518(None) 
shives124921411shives
skives134113941skives
swipes114114331swipes
swive115316191swive_
swived133610631swived
swivel12369321swivel
swivels13396771swivels
swivet123615471swivet
swivets13436961swivets
wives115328921_wives
chives144317592chives
dives95832402_dives
drives105117112drives
dwines105013102dwines
fives116027362_fives
gives95324872_gives
hives116925512_hives
huswives1742932huswives
jives154820812_jives
knives13458552knives
lives86133192_lives
naives94914222naives
ogives10367912ogives
olives94313952olives
reives95723042reives
rives85336002_rives
saices84221802saices
salves94221762salves
saves85838632s_aves
scrives124414272scrives
seines65029902seines
seises64026712seises
seizes154317532seizes
selves94119612selves
serves94423652serves
shaves125224932shaves
shies86136552shi_es
shines95028912shines
shires95225572shires
shivas124512412shivas
shive114423422shive_
shiver124517372shiver
shivers133714832shivers
shivs115018802shiv_s
shoves124919412shoves
shrives134416172shrives
sices75637272s_ices
sides65838362s_ides
sieves93216002sieves
sikes96236082s_ikes
sines55954822s_ines
sipes76036952s_ipes
sires55945372s_ires
sises55233832s_ises
sites56045432s_ites
siver85728612s_iver
sivers95324152s_ivers
sixes124526362s_ixes
sizes146727762s_izes
skies95026832ski_es
skites104418032skites
skive124614112skive_
skived14429892skived
skiver134612102skiver
skivers14409692skivers
slaves95023022slaves
slices84022852slices
slides73922182slides
slieves10378962slieves
slimes84722042slimes
slipes84921412slipes
sliver94116592sliver
slivers104115252slivers
smiles84522292smiles
smites83921922smites
snipes83917392snipes
snivel9368852snivel
snivels10336902snivels
soaves94218672soaves
solves95018222solves
spices104326032spices
spies76037622spi_es
spikes124520712spikes
spiles84227912spiles
spines85132032spines
spires84628112spires
spites84127332spites
spivs105114242spiv_s
staves94525192staves
sties55132982sti_es
stiles64328762stiles
stimes85920572stimes
stipes84524052stipes
stiver93915732stiver
stivers103613532stivers
stoves93818922stoves
strives104119372strives
suites63727402suites
swages104417072swages
swales93920762swales
swedes102711892swedes
swerves1377532swerves
sweven1235982sweven
swevens1334612swevens
swifts12408172swifts
swigs96213662swi_gs
swills94213352swills
swims105514142swi_ms
swine85625302swine_
swinges113413422swinges
swings104714452swings
swinks134610652swinks
swipe105217082swipe_
swiped123811092swiped
swiples12339642swiples
swirls94010132swirls
swishes133411372swishes
swiss86712902swi_ss
swisses10417142swisses
twines94717272twines
waives123714182waives
waves115633922_waves
wides94832822_wides
wifes114522562_wifes
wiles85437872_wiles
wines85546862_wines
wipes104827082_wipes
wires86034912_wires
wises85633192_wises
wites85536962_wites
wive105931752_wive_
wived125121502_wived
wiver115924512_wiver
wivers125320802_wivers
wizes174723342_wizes

Search took 6 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.1261418182.5
2DLD Change Limit825511365.26315685.2
3Display Results1361360.0801700.0
 (SQL Overall)1786911365.46932673.4
 
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.