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

100 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
zorilla164602(None) 
gorilla836971gorilla
zorillas1745481zorillas
zorille1636671zorille
zorillo1644681zorillo
barilla9310322barilla
corolla938622corolla
gorillas946372gorillas
perilla9311232perilla
tortilla845892tortilla
zoril143916692zori_l_
zorilles1736122zorilles
zorillos1743732zorillos
zorils153810882zori_ls
ancilla948603ancilla
armilla936993armilla
axilla13289573_axilla
barillas10310193barillas
brill74819953_brill_
brillo84211003_brillo
brills84916293_brills
cabrilla1245833cabrilla
cedilla1036343cedilla
coria75828323cori__a
corollas1039213corollas
drill64718263_drill_
drills74414203_drills
fibrilla1364373fibrilla
flotilla1143293flotilla
formula1246293formula
frill84917563_frill_
frills94414223_frills
frilly124111443_frilly
gorily10612503gori_ly
grill64617893_grill_
grille74315743_grille
grills74314803_grills
guerilla943793guerilla
holla84918493ho__lla
hydrilla1543473hydrilla
krill94213643_krill_
krills104211283_krills
latilla737953latilla
lorica8310443lori_ca
manilla93012473manilla
maxilla16248193maxilla
megilla1036273megilla
morally12411493morally
morbilli1244963morbilli
morelle91210803morelle
morello9117793morello
morula8710473mor_ula
mouille937843mouille
moviola1244823moviola
noria55722183nori__a
novella1076213novella
olla44821173_o__lla
orally93113593_orally
oriel54920423_oriel_
oriels64914623_oriels
oriole6814293_oriole
orisha936773_orisha
papilla11127913papilla
perillas10310823perillas
prill74117943_prill_
prills84015613_prills
rill45140903__rill_
rille55728733__rille
rills55032713__rills
rouille737493rouille
scilla8310943_scilla
shrill94712303shrill_
shrills10389933shrills
shrilly13318563shrilly
spirilla1045073spirilla
squilla1635533squilla
thrill94910593thrill_
thrills10398783thrills
tornillo854623tornillo
tortillas945183tortillas
torula6610393tor_ula
trill55122933_trill_
trills64319853_trills
vanilla10238743vanilla
variola1068893variola
vexilla1744663vexilla
villa85321233__villa
voila84813943vo_i_la
zariba1736983zari_ba
zill135727613z__ill_
zillah1836563z__illah
zills144020783z__ills
zoaria1548383zoari__a
zoarial1646923zoarial_
zonally1938003zonally
zonula1537223zo_nula
zooglea1733373zooglea
zooidal1745093zooidal
zori137722923zori___
zoris145320013zori__s

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 Filter1786911340270.436409841.7
2DLD Change Limit1340271006.67320085.0
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.15524974.3
 
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.