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

65 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
seracs8441857(None) 
serac75925201serac_
serais64326131serais
derats74625062derats
derays105514252derays
eras45441502_era_s
ferals94216642ferals
gerahs1039412gerahs
mercs96020452mer_cs
rerack122513162rerack
reracks132310532reracks
sacs65739072s__acs
sarans64224432sarans
scrags95713802scrags
scrams105216622scrams
scraps106017242scraps
seals54839702se_als
seams75731662se_ams
search113312422search
sears54744912se_ars
seas45755272se_a_s
seats54844342se_ats
secs65033892se__cs
sedans74816092sedans
selahs9313212selahs
sepals85217382sepals
sera46141392sera__
serai56830162sera_i
serail64222672serail
serails73318362serails
seral56336382sera_l
serape84818412serape
serapes95218102serapes
seraph114011162seraph
seraphs12408092seraphs
serdabs1035322serdabs
seres55448892ser_es
serfs84922012ser_fs
serges74225972serges
serials73919752serials
series64540972series
serifs94017052serifs
serins64029672serins
serous65023562serous
serows96016392serows
sers45746652ser__s
serums83916302serums
servals103410752servals
serves94423652serves
servos93812722servos
sewans95215902sewans
sewars94018632sewars
sferics1236132sferics
soras55041012sora_s
sprags95715822sprags
sprats85819932sprats
sprays115913642sprays
straps87721782straps
strass67117222strass
straws98718672straws
strays96417932strays
sumacs105512102sumacs
surahs94515542surahs
suras55336332sura_s
terais64023512terais

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 Limit82551652.50033020.4
3Display Results65650.0164062.5
 (SQL Overall)178691652.85962501.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.