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

108 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
wisped12341189(None) 
lisped94113421lisped
wimped144211511wimped
wiped114722081wi_ped
wised95123341wis_ed
wished134417511wished
wissed104114641wissed
wisted104120271wisted
aisled74516182aisled
biped104718832bi_ped
cisted95217522cisted
crisped124010102crisped
cusped114312042cusped
dipped123517492dipped
disced104914652disced
dished114318712dished
disked125015762disked
dispel9310322dispel
dispend11289412dispend
dissed85220182dissed
fished134316312fished
fisted104218702fisted
gasped104814292gasped
gimped123911472gimped
gipped124815902gipped
hasped125014442hasped
hipped144317692hipped
hispid1238172hispid
hissed104114452hissed
histed104420242histed
imped105117982_imped
isled64615992_isled
kipped153114572kipped
kissed114412852kissed
limped114817122limped
lipped114419542lipped
lisper84114432lisper
listed74322832listed
misfed124113022misfed
misled94719312misled
mispen10312172mispen
mispled12310462mispled
missed94423602missed
misted93625822misted
nipped113615852nipped
pimped134913482pimped
piped105123162pi_ped
pipped104516542pipped
pished124817062pished
pissed94816932pissed
rasped94715202rasped
riped85226432ri_ped
ripped114419012ripped
risked115514632risked
siped84927682si_ped
sipped113720632sipped
sped76031492__sped
swiped123811092swi_ped
swished14418842swished
tipped114418262tipped
twisted11277432twisted
visaed104110502visaed
vised95518762vis_ed
viseed105310982viseed
waisted114210942waisted
wapped144416472wapped
warped124816412warped
washed135521502washed
wasted104423022wasted
whipped18379332whipped
whished17428022whished
whisked18336912whisked
whisper15298012whisper
whisted144010012whisted
wicked164317412wicked
wifed125117742wi_fed
wigged124413582wigged
wilded113714502wilded
wiled95231552wi_led
willed104722452willed
wilted103915712wilted
wimpled15338822wimpled
winced124415342winced
winded114918212winded
wined94434182wi_ned
winged114620832winged
winked144018602winked
winned104017012winned
wipe94830282wi_pe_
wiper105421292wi_per
wipes104827082wi_pes
wired95327642wi_red
wise75737342wis_e_
wiser85522802wis_er
wises85633192wis_es
wisher123617062wisher
wishes124920952wishes
wisp97124072wisp__
wispier12249402wispier
wisps105214182wisp_s
wispy137210972wisp_y
wisses94619602wisses
wited94727142wi_ted
withed134416232withed
witted104216812witted
wived125121502wi_ved
yipped143613282yipped
zipped203612982zipped

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 Filter178691825510.343520965.0
2DLD Change Limit825511082.19037694.5
3Display Results1081080.0303600.0
 (SQL Overall)1786911082.56369719.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.