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

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
simitar93673(None) 
scimitar1243591scimitar
similar937851similar
simitars1046481simitars
limitary1344932limitary
limiter92710852limiter
scimetar1244042scimetar
scimitars1343172scimitars
scimiter1236142scimiter
seminar979752seminar
simar74920812sim__ar
simian8811162simi_an
simular938672simular
sitar54820542s__itar
smiter83616412s_miter
somital939402somital
bifilar1244043bifilar
bimetal1138433bimetal
digital937063digital
dimeter10411893dimeter
dimity12310473dimit_y
guitar7117443_guitar
imitate9310873_imitate
imitator1047113_imitator
instar6310013_instar
jemidar1744163jemidar
laminar93810283laminar
limier83518723limi_er
limina83514503limina_
liminal93810673liminal
limit73126343limit__
limited102310233limited
limiters10249333limiters
limites92915453limites
limits82514143limit_s
military1347233military
mimbar1297493mim_bar
mimical1339233mimical
minibar11106133minibar
minicar11109313minicar
miter75734793__miter
qintar15359143qi_ntar
rimier83916273rimi_er
sambar103914163sam_bar
sambhar1444853sambhar
samite83020603samit_e
samites93118713samites
samovar1244243samovar
sanitary1146753sanitary
scimetars1344013scimetars
scimiters1345123scimiters
seitan62613233s_eitan
semihard1444673semihard
semimat11412903semimat
semina8915563semina_
seminal91213403seminal
seminars1079043seminars
seminary1398093seminary
semiraw1246053semiraw
shaitan1036893shaitan
sheitan1036573sheitan
shikar1336803s_hikar
shmear1176933shm_ear
sidebar1045563sidebar
sidecar1045233sidecar
siesta639503siesta_
siestas738813siestas
sifter94516233si_fter
sighter113412113sighter
silica8311243silica_
silicas9310603silicas
siltier73413863siltier
sima64730783sim__a_
simars84916933sim__ars
simas75727553sim__as
simians959203simians
similarly1454213similarly
simile83115633simi_le
similes92915233similes
simioid1047993simioid
simious939803simious
simmer104115353sim_mer
simper103616293sim_per
simpler112910863simpler
simulars1047073simulars
sinister838583sinister
sinter63625923si_nter
sirdar7269103si_rdar
sister64421583si_ster
sistra639333si_stra
sitars65417593s__itars
sitter63323383si_tter
sizar145214993s__izar
sizier1514813393sizi_er
slimier93212013slimi_er
smear74416393s_m_ear
smilax1535393s_milax
smiler83916683s_miler
smit65138413s_mit__
smite75224873s_mit_e
smiters93414363s_miters
smites83921923s_mites
smith107818053s_mit_h
smiths114711023s_miths
smithy14508273s_mithy
solitary1146503solitary
somata8312383somata_
somite84519373somit_e
somites94219123somites
somitic111512633somitic
spital83813873s_pital
star48037763s___tar
suiter64121813s_uiter
suitor63311053s_uitor
summital1244703summital
sumpter1138873sumpter
swimwear1641673swimwear
timider1037093timider
unmiter9310393unmiter
unsimilar1152563unsimilar
vimina11339943vimina_
viminal12288823viminal
visiter1038863visiter
visitor1046203visitor
vomiter1237953vomiter

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271256.43620824.6
3Display Results1251250.0462717.4
 (SQL Overall)1786911256.90525878.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.