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

101 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
morello911779(None) 
morelle91210801morelle
morellos10136951morellos
bordello1144712bordello
martello1045092martello
morally12411492morally
morel75729092more_l_
morelles10710492morelles
morels84820012more_ls
zorillo1644682zorillo
amarelle1045613amarelle
amorally1348093amorally
amoretto1095793amoretto
bargello1144143bargello
bordellos1243843bordellos
boreal84817213boreal_
brillo84211003_brillo
cello74919583__cello
cordelle1148433cordelle
corolla938623corolla
duello756783_duello
foredo10510823fore_do
forego1038903fore_go
foreleg1137743foreleg
gorbelly1445463gorbelly
gorilla836973gorilla
hello86522983__hello
hollo84822163ho__llo
jello126716273__jello
loreal63814313loreal_
marengo1035263marengo
martellos1144393martellos
mell64935613m__ell_
mellow114112223m__ellow
mells75031333m__ells
merely111312583mere_ly
micell1098193micell_
micella11106823micella
micelle1178343micelle
micells11107683micells
modally1338403modally
model84521693mode_l_
modeled1139463modeled
modeler1039293modeler
modelled1236433modelled
modeller1136613modeller
models94216353mode_ls
modulo9256983mo_dulo
mohel104914833mohe_l_
mohelim1444763mohelim
mohels115011323mohe_ls
moll66735703mo__ll_
molls75129783mo__lls
molly105222493mo__lly
molto75619603mo__lto
momento11348903momento
monellin1047373monellin
mongrelly1542873mongrelly
moral75533433mor_al_
morale85220553mor_ale
morales93619403morales
morals85324633mor_als
morbilli1244963morbilli
more67154523more___
moreen8313343more_en
moreens939963moreens
mores76249643more__s
morocco1343523morocco
morpho13158443mor_pho
morro73216953mor__ro
morsel85815893morsel_
morseled1147193morseled
morselled1245953morselled
morsels94112653morsels
mortal84616853mortal_
mortally1339933mortally
mortals93914003mortals
morula8710473mor_ula
morulae958963morulae
morular978223morular
morulas959713morulas
motel76623243mote_l_
motels83616893mote_ls
mouille937843mouille
niello636603_niello
novella1076213novella
novelle1058233novelle
novelly1346513novelly
ocelli836843_ocelli
orally93113593_orally
pomelo10238663pome_lo
roselle7310243roselle
sorel56231443sore_l_
sorels63921163sore_ls
sorely94618003sore_ly
torero6313203tore_ro
tornillo854623tornillo
umbrella1243263umbrella
zorilla1646023zorilla
zorille1636673zorille
zorillos1743733zorillos

Search took 10 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.1561145455.1
2DLD Change Limit1340271018.81315207.9
3Display Results1011010.0462195.7
 (SQL Overall)1786911019.01519821.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.