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

85 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
fractals134613(None) 
fractal1237621fractal_
facials123310742f_acials
fracas11311992frac_a_s
fracturs13146312fracturs
fractus12146592fract_us
frontals1146272frontals
ratals64219582_ra_tals
acetals93411353__acetals
brachials16206943brachials
bracteal1245563bracteal_
bracts105617773bract__s
brantails1146313brantails
cantals93919573_cantals
caracals12310753carac_als
craals84113303cra__als
crystals1347173crystals
dactyls1333913_dactyls
exactas16336433exacta_s
facial113615633f_acial_
facias113415803f_acia_s
factors12912123f_actors
facts107021893f_act__s
factual1246723f_actual_
fallals103310193f_allals
fantails1139693f_antails
farfals13268503f_arfals
fatal84819373f_a_tal_
faucals12326563f_aucals
fecials123510333f_ecials
fiscals1238003fisc_als
flatcaps1563403flatcaps
flatcars1344623flatcars
flautas1036153flauta_s
fracases1336993fracases
fracted1339373fract_ed
fracti1139963fract__i
fraction1359483fraction
fractions1449103fractions
fractious1456143fractious
fractur12135563fract_ur
fractural1444553fractural_
fracture13147123fracture
fractures14147233fractures
frails93716473fra__ils
frakturs15163263frakturs
fraters103517213fra_ters
frats86829673fra_t__s
frazils1956123fra_zils
frontal1038363frontal_
graals74112913gra__als
graduals1046203graduals
hartals10313023_hartals
jacals1539873_jac_als
jackals2036893_jackals
kraals10378433kra__als
lactams1136953_lactams
lacteals1095663_lacteals
orbitals1045713orbitals
practicals1645543practicals
racial83419243_racial_
radials83614633_radials
ragtags935373_ragtags
raitas64417673_raita_s
ramtils938413_ramtils
rascals959663_rascals
ratal55025113_ra_tal_
ratans63819373_ra_tans
ratels64518213_ra_tels
rattails837133_rattails
rattans73411953_rattans
recitals1039763_recitals
recoals94214623_recoals
rectal84418133_rectal_
rentals74017473_rentals
rictal83113183_rictal_
sacrals93311793_sacrals
tractable1338513tractable
tractably1646243tractably
tractate10411003tractate
tractates1159763tractates
tractile10311073tractile
tractors10312563tractors
tracts85019073tract__s
uracils939373urac_ils

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 Limit146162857.40619735.6
3Display Results85850.0302833.3
 (SQL Overall)178691857.85922737.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.