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

95 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
acerola94782(None) 
acerolas1048051acerolas
acerose9310892acerose
acerous9513332acerous
areola6813672are_ola
aureola747032aureola
acaroid103512303acaroid
accrual1144553accrual
acedia9310393ace_dia
acequia1844133acequia
acerate92818913acerate
acerb9312763acer__b
acerber1135233acerber
acerbic1335643acerbic
acervuli1341433acervuli
aceta74017353ace__ta
acetal84314903acetal_
acetals93411353acetals
acetone9310793acetone
acetose938843acetose
acetous9410353acetous
acetyl11396553acetyl_
acetyls12285353acetyls
acholia1239973ac_holia
achromat15410103achromat
acicula11228133acicula
acold86214923ac__old
acrobat11411813ac_robat
acromia1139963ac_romia
across8312643ac_ross
actorly1246413actorly
adenoma1045403adenoma
aerial64625713a_erial
aerily93017013a_erily
aero45435343a_ero__
aerobat9514473a_erobat
aerobe8412403a_erobe
aerobia939463a_erobia
aerosat7417183a_erosat
akela9311343ake__la
alertly1046793alertly
anergia847363anergia
aneroid8313983aneroid
araroba945763araroba
areolae7811733are_olae
areolar779223are_olar
areolas71013863are_olas
areole61017283are_ole
aroma71220143a__roma
arroba898663a_rroba
arugola844353arugola
atemoya1242933atemoya
atheroma1354873atheroma
aureolae845313aureolae
aureolas846853aureolas
aureole738693aureole
aurora6411763a_urora
caeoma1039033cae_oma
canola8313623_canola
carol75128613_carol_
caroli85918233_caroli
carols85124983_carols
cedula977643_cedula
cella75420313_ce_lla
ceorl7410913_ceorl_
ceorls848163_ceorls
cercal10314123_cercal
cereal8315833_cereal
ceria75125353_cer_ia
cero66329453_cero__
ceros74726073_cero_s
cerous85821203_cerous
chola104718033_c_hola
chroma132912473_chroma
citola838393_citola
cola66541393_c__ola
corolla938623_corolla
corona83817403_corona
creole8913723_creole
cupola10317693_cupola
ferula93011173_ferula
jackroll2142743jackroll
nerol51017813_nerol_
neroli61111153_neroli
nerols6914883_nerols
pergola1067623_pergola
pteryla1243303pteryla
pyrola1139003_pyrola
reroll6412683_reroll
scleroma1274343scleroma
scroll8310163sc_roll
scrota8310183sc_rota
serosa6313023_serosa
sterol6613323sterol_
sterols7313443sterols

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.1401276364.3
2DLD Change Limit134027956.83019623.3
3Display Results95950.0303166.7
 (SQL Overall)178691957.00025527.3
 
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.