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

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
doggoner114387(None) 
doggone1035681doggone_
doggoned1243881doggoned
doggones1135711doggones
dogger95216782dogg__er
doggier103810942dogg_ier
doggoneder1451082doggoneder
doggonest1244592doggonest
waggoner1343422waggoner
boggier113711583bogg_ier
boggler113910083bogg_ler
commoner142710633commoner
condoner112913413condoner
congener112412203congener
coroner94218203co_roner
dagger95017303dagg__er
deboner103110483d_eboner
digger94616083digg__er
doblones1136763doblones
dodger95817053dodg__er
dodgier10388243dodg_ier
dogbane1135653dogbane_
dogbanes1245433dogbanes
dogged106017703dogg__ed
doggerel1143453doggerel
doggers104413433dogg__ers
doggery13448263dogg__ery
doggie93910893dogg_ie_
doggies103613023dogg_ies
dogging113312693doggin_g
doggo84410703doggo___
doggoning1343563doggoning
doggrel1033883dogg_rel
dognaper1243693dognaper
dogrobber1541333dogrobber
dogvane1243853dogvane_
dogvanes1344303dogvanes
doozer163910463do__ozer
doughier1335483doughier
downer104414923do__wner
dragonet10138953dragonet
droner74717673d__roner
fogger114414783fogg__er
foggier12349913fogg_ier
forgoer1137693forgo_er
forgone1139343forgone_
goggler10379323gogg_ler
gogglier1153923gogglier
goner66025163___goner
hogger114615083hogg__er
jogger154713163jogg__er
joggler16398833jogg_ler
logger86420003logg__er
loggier93811143logg_ier
mooner85317833mo__oner
motioner1037593motioner
orgone71110913_orgone_
orgones81010793_orgones
poisoner1046983poisoner
soggier93410883sogg_ier
sooner64220463so__oner
toggler9399193togg_ler
waggoned1443253waggoned
waggoners1443183waggoners
wagoner1136093_wagoner

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 Filter1786911461620.423422437.4
2DLD Change Limit146162657.18620339.8
3Display Results65650.0164062.5
 (SQL Overall)178691657.62523434.9
 
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.