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

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

103 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
limiteds1118454(None) 
limited102310231limited_
limiters10249331limiters
limites92915451limite_s
liminess10510642liminess
limitedly1542592limitedly
limiter92710852limite_r
limitless1142942limitless
limits82514142limit__s
bilsteds1134273bilsteds
cimices13279803cimice_s
climates12311973climate_s
delimited1346593delimited_
delimiters1345103delimiters
dimeters11411093dimeters
dimities11314003dimities
elicited1139093elicited_
finites10315923finite_s
fomites123613203fomite_s
illites72415013illite_s
imbeds11456743_im_beds
imides94515343_imide_s
imids86015143_imi__ds
imines84918353_imine_s
lameds94812033lam__eds
lamisters1157123lamisters
lamsters1099753lamsters
lenited8812433lenited_
lenites7818443lenite_s
liaised837113liaised_
liaises7311053liaise_s
lichted13268803lichted_
licitness1145373licitness
lifted104413523li_fted_
lifters104313783li_fters
ligated92414143ligated_
ligates82318383ligate_s
lighted122913503lighted_
lightens122510003lightens
lighters123111393lighters
lignites9129613lignite_s
lilied73913213lili_ed_
lilies63021413lili_e_s
lilted73715373li_lted_
limbed114513183lim_bed_
limbers113614743lim_bers
limbless12246313limbless
limeades11116643limeades
limed85426803lim__ed_
limeless10249663limeless
limens84618033lim__ens
limes75636503lim__e_s
limeys11429273lim__eys
limier83518723limi_e_r
limiest93716103limi_est
limit73126343limit___
limitary1344933limitary
limitedness1453893limitedness
limiting1138813limiting
limmers113413083lim_mers
limned94811473lim_ned_
limners93311563lim_ners
limonites1148003limonite_s
limped114817123lim_ped_
limpers113815223lim_pers
limpets11329783lim_pets
limpness1246703limpness
linseeds944733linseeds
linted74021823li_nted_
lintels73311163li_ntels
linters73822633li_nters
lipides103810623lipide_s
lipids94310923lipi__ds
listed74322833li_sted_
listees73416673li_stees
listels74212433li_stels
listens74014133li_stens
listers74026533li_sters
liters65429883l__iters
litotes7311183litote_s
litters73422573li_tters
liviers104211073livi_ers
loiters74116613l_oiters
lucites9311863lucite_s
miters84328783__miters
mites75141803__mite_s
pinites9319533pinite_s
plumipeds1641663plumipeds
riminess10510093riminess
samites93118713samite_s
scimiters1345123scimiters
similes92915233simile_s
simitars1046483simitars
sliminess1137423sliminess
smiters93414363_smiters
smites83921923_smite_s
somites94219123somite_s
unlimited1245923unlimited_
unmiters1037073unmiters
visited1168773visited_
visiters1137413visiters
vomited1337253vomited_
vomiters1337203vomiters

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621037.40619735.6
3Display Results1031030.0333121.2
 (SQL Overall)1786911037.85922737.1
 
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.