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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
litmuses104446(None) 
citruses1037482citruses
limbuses1234902limbuses
litmus836322litmu__s
lotuses74011252lot_uses
situses72710492sit_uses
airbuses1067073airbuses
amuses85117943__amuses
animuses1037983animuses
bemuses1139293_bemuses
circuses1238253circuses
cistuses1038283cistuses
coituses1039623coit_uses
diffuses1534823diffuses
dinguses1037643dinguses
discuses113112863discuses
diseuses93112763diseuses
disuses84015413di_suses
enthuses1138253enthuses
estruses838483estruses
fetuses10310243fet_uses
ficuses12159203fi_cuses
flatuses1137173flat_uses
glimpses1343953gli_mpses
halituses1245573halit_uses
hiatuses1135773hiatuses
hummuses1544453hummuses
humuses1237593_humuses
iambuses1235783_iambuses
ictuses938303_ictuses
ileuses738673_ileuses
immunes1136083_immunes
immures1136713_immures
incuses93514853_incuses
infuses102711873_infuses
isthmuses1442973isthmuses
itemises1087693_itemises
lemures938793l_emures
lettuces1043503lettuces
liaises7311053li_aises
licenses10118923licenses
ligases82310713li_gases
ligules82210923li_gules
ligures8269893li_gures
limes75636503li_m__es
limites92915453li_mites
limpsey14365093li_mpsey
limulus935083li_mulus
lionises8310313lionises
lipases9209483li_pases
litanies8310993litanies
liteness82213213liteness
lithiases1244773lithiases
litotes7311183lit_otes
litres65220393lit__res
littles73212783lit_tles
lotoses73713643lot_oses
louses66230283l__ouses
lupuses936273l_upuses
lususes736713l_ususes
mimeses1139073mi_meses
minuses93512703mi_nuses
missuses10309683missuses
misuses93216023mi_suses
mitises9315543mit_ises
mitoses9312183mit_oses
mittimuses1452463mittimuses
momuses1159263_momuses
muses75134303___muses
niduses837013ni_duses
nimbuses1244663nimbuses
primuses1237083primuses
rictuses1037563rictuses
risuses73210923ri_suses
shamuses1336153shamuses
siameses1036403siameses
sinuses73011593si_nuses
thymuses1643073thymuses
titmouse1043133titmouse_
tmeses85712243__tmeses
touses64229673__touses
trismuses1143633trismuses
viruses1039413vi_ruses
vitesses1136333vitesses
wammuses1543493wammuses
wamuses1237023_wamuses

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 Limit146162867.15620425.1
3Display Results86860.0332606.1
 (SQL Overall)178691867.60923484.2
 
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.