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 “freaks” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

72 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
freaks13471306(None) 
breaks124816421breaks
creaks124315961creaks
freak125115241freak_
freaky16439231freaky
wreaks134711111wreaks
araks94820882ar_aks
areas55935772area_s
beaks115326622_beaks
bleaks125112432bleaks
breads95419202breads
break115319402break_
breams104815042breams
breeks125310792breeks
creak115418432creak_
creaky154911552creaky
creams104715252creams
creeks124812922creeks
croaks125812982croaks
dreads84115022dreads
dreams94513982dreams
drears74614252drears
drecks13459202drecks
dreks105714752dre_ks
fears84829392f_ears
feats86432752f_eats
fecks145417852f_ecks
ferals94216642ferals
fleams115011942fleams
fleas86423662flea_s
flecks154310802flecks
frags96322172fr_ags
franks134912732franks
fraps105620552fr_aps
frass85321122fr_ass
frats86829672fr_ats
frays116920102fr_ays
freaked15399702freaked
freakish1845542freakish
freers94717302freers
frees86131392fre_es
freres94716172freres
frets85523402fre_ts
friars93812092friars
frisks13479262frisks
frocks154111212frocks
greats76318392greats
leaks95923912_leaks
oreads73915772oreads
peaks114825622_peaks
phreaks1634542phreaks
reads64835272_reads
reals55038652_reals
reams75729622_reams
reaps75626192_reaps
rears54739652_rears
recks115625132_recks
reeks94124032_reeks
screaks13469362screaks
sneaks104312492sneaks
speaks125114582speaks
steaks104415852steaks
streaks114411272streaks
teaks94222902_teaks
treads74817922treads
treats64821692treats
treks96016852tre_ks
troaks104410602troaks
tweaks1335962tweaks
ureas55826012urea_s
wreak125513272wreak_
wrecks15418882wrecks

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit82551722.42334069.7
3Display Results72720.0332181.8
 (SQL Overall)178691722.79963841.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.