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

82 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
freesia104632(None) 
freesias1146331freesias
freebie1236042freebie
frees86131392frees__
freest95318282frees_t
agenesia945983agenesia
amnesia938293amnesia
atresia7310223atresia
babesia1146623babesia
breccia1344453breccia
brees75632553brees__
creepie1137483creepie
creese84014333crees_e
creeses93914623creeses
creesh11328333crees_h
drees65628523drees__
erepsin937383erepsin
fees76450603f_ees__
felsic1147053f_elsic
feres86038183feres__
feria85922713f__eria
fiesta938123f_iesta
flees85828753flees__
forensic1344943forensic
fraena938063frae_na
frambesia16142033frambesia
free75940183free___
freebee1238043freebee
freebies1337873freebies
freed95223543free__d
freedman1444143freedman
freedom1345853freedom
freeing113713913freeing
freeload1244733freeload
freely12310953free_ly
freeman1237343freeman
freemen1238463freemen
freer86021243free__r
freers94717303free_rs
freeway1635603freeway
freewill1443413freewill
freeze18349513free_ze
freezer19348523freezer
freezes193310353freezes
freezing21308323freezing
frena85915273fr_e_na
frenetic1346293frenetic
frenula1045623frenula
freres94716173freres__
fresco1136473fr_esco
fresh115012203fr_es_h
frets85523403frets__
fretsaw1343923fretsaw
fries85535603fries__
froes86126693froes__
frusta937453fr_usta
fuchsia15123573fuchsia
greenie8310123greenie
grees65132473grees__
pereia85217983pere_ia
preedit10512453preedit
preemie11310563preemie
prees75937173prees__
presa74319043pr_es_a
realia6314593_realia
redia65524483_r_edia
reedit7617223_reedit
reemit8717223_reemit
rees45364193_rees__
reest54938093_rees_t
reests64618893_reests
reseda739703_reseda
resid64124093_r_esid
resin54131053_r_esin
resit54241043_r_esit
retia55326113_r_etia
retsina74710603_retsina
silesia739083silesia
trees55835763trees__
uraemia946503uraemia
uredia73610063ur_edia
uremia82910893ur_emia

Search took 10 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.313570897.8
2DLD Change Limit134027829.09314739.6
3Display Results82820.0332484.8
 (SQL Overall)178691829.43918931.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.