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

121 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
unmitres103686(None) 
unmiters1037071unmiters
unmitre936991unmitre_
unmitred1136841unmitred
enmities10611352enmities
mitres83922072__mitres
nitres65519332_n_itres
uniters73814172un_iters
unites65024852un_it_es
unities72520152un_ities
unmiter9310392unmit_er
unmitered1245852unmitered
unmixes16197752unmi_xes
admires1038663admi_res
amities9317383_amities
antres65021003an__tres
bemires113212833bemi_res
comities12317793comities
dimities11314003dimities
dunites8313593dun_it_es
dunnites947173dunnit_es
emigres1037673_emigres
endites83717063endit_es
entires71517783enti_res
entities8617413entities
entitles8710663entitles
fomites123613203fomit_es
furmities1447543furmities
goitres8389563_goitres
gummites1346173gummit_es
gunfires1235063gunfi_res
gunites8313123gun_it_es
humitures1444303humitures
inciters103210673inciters
incites93218483incit_es
inditers93311053inditers
indites83618983indit_es
inmates92715783inmat_es
intitles8710003intitles
invitees11377903invitees
inviters11359643inviters
invites103915813invit_es
kunzites2143243kunzit_es
limiters10249333limiters
limites92915453limit_es
litres65220393__litres
matres84522233__matres
metres85121563__metres
mires75640883__mi_res
miters84328783__miters
mites75141803__mit_es
mitre75522423__mitre_
mitred94414343__mitred
niters64624213_n_iters
nites55736343_n_it_es
nitre57519683_n_itre_
nitros64214123_n_itros
nudities939683nudities
punditries1343753punditries
samites93118713samit_es
smiters93414363_smiters
smites83921923_smit_es
somites94219123somit_es
summitries1444643summitries
titres64718933__titres
umpires1137813u_mpires
unaired82916013unai_red
unakites1237543unakit_es
unawares1137053unawares
unbitted1138213unbitted
unbitten1045213unbitten
unbitter1046173unbitter
undies73821963undi__es
undines8716083undi_nes
unfired112212453unfi_red
unfitness1244843unfitness
unfits93910293unfit__s
unfitted1238163unfitted
unfixes17238113unfi_xes
ungirds9105303ungi_rds
unhinges12266723unhinges
unhired112512153unhi_red
unhitches1743073unhitches
unifies102714713un_ifies
uniques1667443un_iques
unitages938273un_itages
unitards945623un_itards
unite54828383un_it_e_
united74421543un_it_ed
uniter64619143un_it_er
unitizes1739133un_itizes
unitrust845563un_itrust
units54923433un_it__s
unlives102010953unli_ves
unmakers14256653unmakers
unmakes132810793unm_akes
unmarred11258403unmarred
unmated103317023unmat_ed
unmatted1138293unmatted
unmatured1245693unmatured
unmeshes1346153unmeshes
unmilled1197853unmilled
unmined102612953unmi_ned
unmingles1243983unmingles
unmitring1245263unmitring
unmixed17228213unmi_xed
unmoored1137333unmoored
unmoors945903unmoor_s
unpiles92112783unpi_les
unpitied1138793unpitied
unpitted1148623unpitted
unretires945933unretires
unstress837373un_stress
untidies939813untidies
unties64326923un__ties
untired82316383unti_red
untitled978763untitled
unwishes14147483unwishes
unwits9389893unwit__s
unwitted1237543unwitted
vomiters1337203vomiters

Search took 9 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 Limit1461621217.73618893.7
3Display Results1211210.0462630.4
 (SQL Overall)1786911218.18821823.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.