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

89 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
dovens10441390(None) 
covens114919261covens
davens104612911davens
doven94718551doven_
doves94728151dove_s
doyens104810221doyens
dozens164612461dozens
ovens86217451_ovens
wovens12449831wovens
avens86419332_avens
codens94821012codens
copens106119962copens
coven106925042coven_
covers114627962covers
coves105539172cove_s
covets114819642covets
coveys145413502coveys
covins114618062covins
cozens176314922cozens
daven94916472daven_
dens55945072d__ens
deveins1138812deveins
devels104313902devels
devons104512252devons
divans104612392divans
divers105024962divers
dives95832402dive_s
dizens164911392dizens
docent92918682docent
docents102810802docents
doers65225712do_ers
does56554472do_e_s
doges75630162doge_s
dogeys115510662dogeys
doles67843752dole_s
dolmens10388692dolmens
domes85735562dome_s
donees74519492donees
dons56048702do__ns
dopers95522482dopers
dopes84935042dope_s
dosers75723632dosers
doses65938502dose_s
doters74423912doters
dotes65836692dote_s
dove85131562dove__
dovened12389062dovened
dowels104813342dowels
dowers104523292dowers
downs94918572do_wns
doyen95014412doyen_
dozen155017472dozen_
dozers164815422dozers
dozes155226302doze_s
drovers115212642drovers
droves105116672drove_s
duvets1039222duvets
evens84817102_evens
foveas1238622foveas
givens10379732givens
governs1136102governs
havens124514042havens
hovels125413342hovels
hovers124320252hovers
livens94314892livens
lodens74315062lodens
lovers94223432lovers
loves85332012love_s
mavens114312972mavens
movers115117192movers
moves106128422move_s
novels95512502novels
novena936762novena
novenas1036892novenas
omens75618962_omens
opens76118552_opens
oven76624142_oven_
overs85224792_overs
ravens93916882ravens
rouens64814442rouens
roven85521972roven_
rovers95423522rovers
roves84834482rove_s
rowens94515302rowens
sevens93813662sevens
slovens10316572slovens
sowens93613152sowens
tokens104711562tokens
woven115215172woven_

Search took 7 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.846211218.7
2DLD Change Limit82551895.28015634.7
3Display Results89890.0631412.7
 (SQL Overall)178691896.18928872.4
 
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.