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

134 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
arillate841299(None) 
areolate81014452areolate
argillite1044372argillite
arillode944962arillode
aristate8312132aristate
armillae1045562armilla_e
axillae14248232axilla_e
grillade1085142grillade
grillage1055612grillage
papillate13127572papillate
vacillate1456852vacillate
variolate1248552variolate
ablate82219213a__blate
abollae936943abolla_e
aciculate132510803aciculate
acidulate12256893acidulate
acierate10311813acierate
acrylate1347693acrylate
aculeate1039923aculeate
acylate12310533a_cylate
adulate8313233a_dulate
affiliate1545323affiliate
agitate8312063agi_tate
airdate8311323a_irdate
airplane1067793airplane
alate55340333a___late
alienate8311553alienate
alkylate1554663alkylate
ambulate1239733ambulate
amirate91115953ami_rate
ancillae1047653ancilla_e
angulate9312013angulate
animate91617213ani_mate
annulate8310923annulate
apholate13410473apholate
apiculate13279883apiculate
appellate1346193appellate
arbitrate11137373arbitrate
arcuate9311963ar_cuate
areolae7811733areola_e
areolated1089713areolated
argillites1143483argillites
ariette7312373ari_ette
arillodes1044683arillodes
arilloid946623arilloid
aristae7312533arista_e
armilla936993armilla__
armillary1443913armillary
armillas1046663armilla_s
arrogate91210323arrogate
arsenate81010483arsenate
articulate12410243articulate
auriculate1246493auriculate
avellane1146263avellane
aviate9315203avi__ate
axilla13289573axilla__
axillar14247563axilla_r
axillars15235993axillars
axillary18235103axillary
axillas14278963axilla_s
barilla9310323barilla__
barillas10310193barilla_s
bullate93415073_bullate
cantillate1247343cantillate
carinate103320253cari_nate
carpellate1445333carpellate
ciliate9514603_ciliate
collate92919683_collate
corollate1148123corollate
crispate1246913crispate
cristate10310603cristate
dilate73220693_di_late
drillable1245133drillable
epilate9314283epi_late
etiolate849523etiolate
fellate10313433_fellate
fibrillate1563543fibrillate
filiate10414233_filiate
frigate11311063fri_gate
gallate83417133_gallate
grillades1194543grillades
grillages1174943grillages
grille74315743grill__e
illite63414923__illite
labellate11126923labellate
lamellate11116703lamellate
marinate103017783mari_nate
maxillae17256723maxilla_e
millage103112753_millage
ocellate1037873ocellate
oeillade943953oeillade
oscillate1145473oscillate
papillae12137023papilla_e
papillote1394093papillote
patellate1147483patellate
pileate93815923_pileate
pillage103412603_pillage
prelate9519693pr_elate
primate111516283pri_mate
priorate10411733priorate
private121513263pri_vate
prolate9419793pr_olate
reflate103516263_reflate
relate64033633_r_elate
replate93420053_replate
reslate73520593_reslate
rille55728733_rill__e
rillet64828853_rillet_
rillets74216153_rillets
spillage1146263spillage
stellate8310503stellate
tailgate946823tailgate
tillage83111343_tillage
tillite7313563_tillite
titillate945583titillate
treillage1043673treillage
tribulate1148083tribulate
trilobate1145433trilobate
triplane1039113triplane
triplite1039103triplite
tristate8311033tristate
urinate7315363uri_nate
vacillated1654633vacillated
vacillates1555723vacillates
vallate103016563_vallate
variate101316433vari__ate
variegate1344103variegate
variolated1445403variolated
variolates1347463variolates
variolite1248083variolite
vexillate1944553vexillate
villae95615383_villa_e
village113610833_village
violate10311553_violate

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.423422437.4
2DLD Change Limit1461621346.89021213.6
3Display Results1341340.0632127.0
 (SQL Overall)1786911347.37624226.0
 
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.