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

87 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
voided11401113(None) 
avoided1235551avoided
loided83414021loided
voiced123910111voiced
voider103611551voider
abided105313312abided
aided75828932_aided
avoider1155812avoider
bided95424962_bided
boded95124962bo_ded
bodied103814582bodied
boiled95020952boiled
bonded104719952bonded
chided135113962chided
codded114515302codded
coded95433182co_ded
coifed124113062coifed
coiled95123932coiled
coined94523602coined
corded105923352corded
doiled84817292doiled
doited85016632doited
elided84814672elided
foiled104618402foiled
foined105915012foined
folded114212792folded
fonded115717042fonded
forded115020392forded
glided94513902glided
goaded94913712goaded
godded104811802godded
grided95117042grided
guided94014112guided
hided105222442_hided
hoiden103612332hoiden
hoised105117432hoised
hooded114616742hooded
horded115420482horded
joined144613072joined
loaded84616872loaded
lorded84916732lorded
moiled94318862moiled
molded104414082molded
nided75920872_nided
nodded94012122nodded
noised75416232noised
oiled64429472_oiled
podded115012712podded
poinded11358972poinded
poised94918472poised
ponded105218772ponded
prided103618032prided
raided85017702raided
rodded93713702rodded
roiled74320052roiled
sided74825952_sided
sodded94113302sodded
soiled73822472soiled
tided76322512_tided
toiled74420322toiled
toited74016752toited
vailed104619292vailed
veiled103714542veiled
veined104413912veined
vended114416352vended
viced115118182v_iced
vide85432752v_ide_
video96014952v_ideo
vied86328632v_i_ed
vined95626152v_ined
vised95518762v_ised
vogued11457632vogued
voice104915322voice_
voicer113910542voicer
voices114414012voices
void86220562voi__d
voiders11279822voiders
voids95414672void_s
voile84719722voile_
voiles94616442voiles
voled95323722vo_led
vomited1337252vomited
voted93919142vo_ted
vowed124424572vo_wed
woaded115211602woaded
wooded114213682wooded
worded114316622worded

Search took 4 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.1101624463.6
2DLD Change Limit82551873.76621920.1
3Display Results87870.0601450.0
 (SQL Overall)178691873.93645399.1
 
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.