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

119 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
scimiter123614(None) 
scimitar1243591scimitar
scimiters1345121scimiters
limiter92710852_limiter
scamster1235302scamster
scimetar1244042scimetar
scimitars1343172scimitars
simitar936732s_imitar
slimier93212012slimi_er
smiter83616412s__miter
accipiter15133743accipiter
animater101512393animater
cimices13279803_cimices
citer74827333_c__iter
deciliter1247033deciliter
decimeter14147413decimeter
delimiter1246243delimiter
dimeter10411893_dimeter
grimier103210433grimi_er
limier83518723_limi_er
limited102310233_limited
limiters10249333_limiters
limites92915453_limites
miter75734793___miter
oximeter1755153oximeter
rimier83916273_rimi_er
salimeter1157373salimeter
samite83020603s_amite_
samites93118713s_amites
scalier94316913scali_er
scammer133611973scam_mer
scamper134613163scam_per
scamsters1334993scamsters
scanter94215183sc_anter
scantier10309983scantier
scarier94017873scari_er
scatter93815173sc_atter
scattier10267583scattier
scepter1138363sc_epter
schizier2234063schizi_er
schmeer1475363schm_eer
scilicet1249543scilicet
scimetars1344013scimetars
scooter93312873sc_ooter
scoter83815483sc__oter
scouter93313323sc_outer
scriber113910973sc_riber
scrimper1455763scrim_per
scrimpier1554243scrimpier
scripter12137783scripter
scummer13398753scum_mer
scummier1445083scummier
scutter93512173sc_utter
seamier93114633seami_er
seamster1037143seamster
shifter132911083shi_fter
shiftier1436343shiftier
shimmer143310873shim_mer
shinier104113143shini_er
shirtier1137943shirtier
shittier1137313shittier
sifter94516233s_i_fter
sighter113412113s_ighter
siltier73413863s_iltier
similar937853s_imilar
simile83115633s_imile_
similes92915233s_imiles
simitars1046483s_imitars
simmer104115353s_im_mer
simper103616293s_im_per
simpler112910863s_impler
sinister838583s_inister
sinter63625923s_i_nter
sister64421583s_i_ster
sitter63323383s_i_tter
sizier1514813393s_izi_er
skimmer15327533skim_mer
skimpier1634293skimpier
skirter11338483ski_rter
skitter113810403ski_tter
slighter1257823slighter
slimmer114211343slim_mer
slimsier1085213slimsier
slitter73615873sli_tter
slittier837003slittier
smiler83916683s__miler
smite75224873s__mite_
smiters93414363s__miters
smites83921923s__mites
snifter10349623sni_fter
somite84519373s_omite_
somites94219123s_omites
spicier115112463spici_er
spikier13369983spiki_er
spinier93715163spini_er
spinster1036683spinster
spirier93214073spiri_er
spirited1148973spirited
spitter94015183spi_tter
spumier1137903spumi_er
stimied10310623stimi_ed
stimies9316563stimi_es
stinter73614513sti_nter
stipites1039653stipites
straiter8311783straiter
submitter1345283submitter
suiter64121813s__uiter
summited13246413summited
summiteer1343003summiteer
sumpter1138873s_umpter
surmiser1036763surmiser
swifter13318053swi_fter
swimmer14297653swim_mer
swimmier15174313swimmier
timider1037093_timider
trimeter10310083trimeter
unmiter9310393_unmiter
visiter1038863_visiter
vomiter1237953_vomiter

Search took 7 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.406440125.6
2DLD Change Limit1461621196.42322756.0
3Display Results1191190.0462587.0
 (SQL Overall)1786911196.87525991.4
 
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.