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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
dehorner123552(None) 
dehorned1345681dehorned
dehorners1344741dehorners
deboner103110482debo_ner
deforcer14246902deforcer
deformer14247942deformer
dehorn10439652dehorn__
dehorns11428362dehorn_s
dehorted1357302dehorted
deporter1169392deporter
dethroner1344482dethroner
dewormer14256322dewormer
abhorrer1343383abhorrer
adorner8246973_adorner
beholder1435053beholder
bethorned1544443bethorned
churner12298343_churner
corner84625623__corner
darner74017303d__arner
deadener1036743deadener
dearer74822803de_ar_er
debarker15155503debarker
debone93714783debo_ne_
deboned113411633debo_ned
deboners11268113debo_ners
debones103315113debo_nes
decerned1237263decerned
decliner113710843decliner
decoder113712293deco_der
decoyer13348683deco_yer
decreer10269123de_creer
decrier102713553de_crier
deepener1145183deepener
deferrer12135593deferrer
definer114413773de_finer
defoamer14276213defoamer
defogger1443533defogger
deforce13267243deforce_
deforced15247373deforced
deforcers15265503deforcers
deforces14248403deforces
deformed15248263deformed
deformers15266533deformers
dehorning1455243dehorning
dehort104618103dehor__t
dehorts11379773dehor_ts
dejeuner1682933dejeuner
delouser936363delouser
demerger12127373demerger
demurer1037873demur_er
demurrer1144043demurrer
denouncer1244133denouncer
deplorer1136343deplor_er
depone93616553depo_ne_
deponed113712873depo_ned
depones103717093depo_nes
deported1249703deported
deportee11510353deportee
deporters1277793deporters
deposer104011843depo_ser
dernier83011943de__rnier
descrier1157623descrier
deserter91211603deserter
deserver12118383deserver
designer1036543designer
desirer8310783desir_er
desorbed1236433desorbed
destrier9311823destrier
detainer92910793detainer
deterger10147593deterger
deterrer9137013deterrer
dethrone1247563dethrone_
dethroned1445073dethroned
dethroners1443623dethroners
dethrones1347313dethrones
devourer1235063devourer
devouter1235513devouter
dewormed15236223dewormed
dewormers15255193dewormers
disorder1038123disorder
divorcer1444033divorcer
dormer94415893d__ormer
dorper94314563d__orper
dorser74819173d__orser
downer104414923d__owner
droner74717673d_ro_ner
drowner11369803d_rowner
earner63617223_e_arner
eloiner7149183_eloiner
exhorter1845353exhorter
honer85332093__ho_ner
horned105718703__horned
hornet94926433__hornet
hornier103012453__hornier
learner7319383le_arner
recorder11249633recorder
reformer13217953reformer
reorder8239483re_order
reporter10411423reporter
resorter8312173resorter
retorter8410733retorter
returner8397983returner
schooner1336623schooner
scorner9259763_scorner
shorter103515493_shorter
sorner64720383__sorner
suborner1047383suborner
tenoner739683teno_ner
thorned11479403_thorned
thornier1135323_thornier
yearner10336873ye_arner

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.1531167915.0
2DLD Change Limit1461621117.50319480.5
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.70223200.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.