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

125 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
swipe10521708(None) 
sipe67341041s_ipe
slipe75626131slipe
snipe75320571snipe
stipe76523371stipe
swine85625301swine
swiped123811091swiped
swipes114114331swipes
swiple11379231swiple
swive115316191swive
wipe94830281_wipe
cripe95521142cripe
dwine95616142dwine
gripe84622962gripe
gwine95513662gwine
lipe66839732_lipe
pipe86434432_pipe
ripe66038922_ripe
saice75424052saice
scape96921842scape
scope94821482scope
seine55732872seine
seise54727852seise
seize143819502seize
shape105125112shape
shine85533092shine
ship95228242ship_
ships105123772ships
shire84727132shire
shive114423422shive
sice65545592s_ice
side55444492s_ide
sike87138782s_ike
sine46560622s_ine
sip57656012s_ip_
siped84927682s_iped
sipes76036952s_ipes
sips65740102s_ips
sire46150412s_ire
site47052412s_ite
size135630962s_ize
skip105421752skip_
skips115616602skips
skite95120052skite
skive124614112skive
slice74925822slice
slide64725412slide
slime74925752slime
slip67031732slip_
sliped95417062sliped
slipes84921412slipes
slips76023722slips
slipt76627482slipt
slope75823562slope
slype105112362slype
smile74823922smile
smite75224872smite
snide64318722snide
snip66424652snip_
sniped94913482sniped
sniper84413642sniper
snipes83917392snipes
snips75818012snips
spice95528812spice
spike114922842spike
spile75230082spile
spine76534422spine
spire75828692spire
spite75430662spite
stile54931572stile
stime76521802stime
stiped94517072stiped
stipel84412122stipel
stipes84524052stipes
stope74727242stope
stripe85822442stripe
stupe75217752stupe
suite54829562suite
supe65932762s_upe
swage94919562swage
swale85221592swale
swap95925432swap_
swaps104819202swaps
sware85828212sware
swede94413202swede
sweep104715722sweep
swept105720602swept
swift116818052swift
swig85818022swi_g
swigs96213662swigs
swill83417372swill
swim96221402swi_m
swims105514142swims
swing96124842swing
swinge105614382swinge
swink125116352swink
swiples12339642swiples
swipple1444632swipple
swirl84514142swirl
swish115114822swish
swiss86712902swiss
swith115917402swith
swithe124010682swithe
swived133610632swived
swivel12369322swivel
swives123915182swives
swivet123615472swivet
swop95120502swop_
swops105913972swops
swore84920822swore
tripe75425382tripe
twice104711122twice
twine85822362twine
wide85235412_wide
wife105228022_wife
wile75944372_wile
wine74953422_wine
wiped114722082_wiped
wiper105421292_wiper
wipes104827082_wipes
wire75839812_wire
wise75737342_wise
wite75443272_wite
wive105931752_wive
yipe96722182_yipe

Search took 2 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.296603685.8
2DLD Change Limit538001251.64032804.9
3Display Results1251250.0462717.4
 (SQL Overall)1786911251.98290156.9
 
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.