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

141 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
fractal123762(None) 
fractals1346131fractals
bracteal1245562bracteal
facial113615632f_acial
factual1246722f_actual
fatal84819372f_a_tal
fracas11311992frac_as
fracted1339372fracted
fracti1139962fract_i
fractur12135572fractur
fractural1444562fractural
fractus12146592fractus
frontal1038362frontal
racial83419242_racial
ratal55025112_ra_tal
rectal84418142_rectal
rictal83113192_rictal
acetal84314903__acetal
acta69524803__acta_
actual8311023__actual
artal55525473__artal
biracial12107973biracial
brachial15219303brachial
bract96332723bract__
bracted12410933bracted
bracts105617773bract_s
brantail1046893brantail
brutal859383br_utal
cantal84122033_cantal
caracal11312513carac_al
chaetal1238283chaetal
coastal9411043coastal
craal74117753cra__al
cranial92114683cranial
crestal9312133crestal
crucial1157893crucial
crustal939023crustal
cryptal1445683cryptal
crystal1237433crystal
dactyl1234983_dactyl
ductal938993_ductal
edictal1046993edictal
exacta15337393exacta_
exactas16336433exactas
facia103218463f_acia_
faciae112913413f_aciae
facials123310743f_acials
facias113415803f_acias
fact97142543f_act__
factful1536373f_actful
factor11911463f_actor
facts107021893f_act_s
facula112912233f_acula
faecal11359813f_aecal
fallal93612693f_allal
fantail10310233f_antail
farcical1546953farcical
farfal123410183f_arfal
fascial1258303fascial
faucal11339963f_aucal
faucial1257323faucial
faunal94711593f_aunal
fecal105119213f_ec_al
fecial114714623f_ecial
festal94213563f_estal
fetal85623373f__etal
fiscal1139333fisc_al
flatcap1463653flatcap
flatcar1274613flatcar
flauta937823flauta_
flautas1036153flautas
focal104917673f_oc_al
foetal9311883f_oetal
fontal9313143f_ontal
forestal11410283forestal
fraction1359483fraction
fractional1547133fractional
fracture13147143fracture
fracturs13146323fracturs
fraena938063fraena_
frail85220213fra__il
fraktur14153043fraktur
frantic12310373frantic
frat75648543fra_t__
frater94520593fra_ter
frats86829673fra_t_s
frazil1847223fra_zil
frontals1146273frontals
frugal1036393fr_ugal
frusta937453frusta_
glacial1038143glacial
graal64316503gra__al
gradual936943gradual
hartal9415473_hartal
hiatal9310203hia_tal
jacal14313703_jac_al
jackal1937613_jackal
kraal94511823kra__al
lactam10310943_lactam
lacteal966823_lacteal
marital92314183marital
meatal84114733mea_tal
natal53921493_na_tal
octal71214723__octal
orbital936923orbital
practic13312253practic
practical1548843practical
quantal16367893quantal
rachial122012173_rachial
radial74020393_radial
ragtag836643_ragtag
raita54623073_raita_
raitas64417673_raitas
ramal74622243_ra_mal
ramtil8311033_ramtil
rascal8511123_rascal
ratals64219583_ra_tals
ratan53722663_ra_tan
ratel54224883_ra_tel
rattail737803_rattail
rattan63613603_rattan
recital9412173_recital
recoal84117983_recoal
recta74220263_recta_
rental63922033_rental
sacral83414413_sacral
spacial1138763spacial
statal61613223sta_tal
stratal72710603stra_tal
tactual936203_tactual
tectal83713253_tectal
tracheal1348253tracheal
tract75635713tract__
tractable1338513tractable
tractably1646243tractably
tractate10411003tractate
tractile10311073tractile
tractor9311343tractor
tracts85019073tract_s
trochal1288243trochal
uracil8311543urac_il

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.393454684.5
2DLD Change Limit1340271416.59320328.7
3Display Results1411410.0463065.2
 (SQL Overall)1786911417.03225411.1
 
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.