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

100 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
redowa1038451redowa_
redowas1138391redowas
recoat84024272reco_at
redcoat10410882redcoat
redoubt10167842redoubt
redout71820252redo_ut
aerobat9514473aerobat
aerosat7417183aerosat
doat56947673__do_at
fedora1038593fedora_
fedoras1137923fedoras
pedocal1237893pedocal
readopt10410843reado_pt
readout8615513reado_ut
reboant9315093reboant
reboot84119333rebo_ot
recheat12415933recheat
recoal84117983reco_al
recoats92616643reco_ats
recount9315173recount
redact9419043red_act
redan66125013red__an
redate74124683red__ate
redbait1039803redbait
redbay1238333red_bay
redcap1158493red_cap
redcoats1147123redcoats
reddest9311953reddest
redear73515173red_ear
redefeat1246313redefeat
redhead1257053redhead
redia65524483red_ia_
rediae74221993red_iae
redial74923113red_ial
redias74523603red_ias
redipt94116743red_ipt
redo56029373redo___
redock134311543redo_ck
redocks14409933redocks
redoes74623773redo_es
redoing93516733redoing
redolent9411883redolent
redon65424883redo__n
redone74820053redo_ne
redons75222183redo_ns
redos65126763redo__s
redoubts11153973redoubts
redound968173redound
redouts81411663redouts
redox134714233redo__x
redoxes15310883redoxes
redraft11310573redraft
redraw10269853red_raw
redrawn11245953redrawn
redraws11218473redraws
redream10107913redream
redreamt11127183redreamt
redroot8312903redroot
redstart949193redstart
redware1139363red_ware
redwood1236523redwood
refloat10310833refloat
reformat1357653reformat
reheat94423943re_heat
reload7413893relo_ad
reloan6415693relo_an
relocate10713533relocate
remora8414593remora_
remoras9314073remoras
remount9512283remount
removal1236733removal
renewal1038713renewal
renovate1138553renovate
renown9369983renow_n
renowns10277833renowns
repeat85127213re_peat
report85326023repo_rt
reposal939113reposal
reposit9315863reposit
repot75132623repo__t
repower12329883repower
resat55139683re__sat
reseat64131493re_seat
resoak10311093reso_ak
resojet14312823resojet
resonant8410813resonant
resonate8513513resonate
resort65728623reso_rt
resow88217243resow__
resowed113712263resowed
resown94112923resow_n
resows93915353resow_s
retort66831153reto_rt
retotal739843retotal
retreat7317533retreat
revolt9316223revo_lt
rewan85623663re__wan
rewax155713923re__wax
rewet85135153re__wet
rowan85418733r__owan

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.406440125.6
2DLD Change Limit1340271007.48317910.9
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.93522519.3
 
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.