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

246 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
diviners1230835(None) 
dividers13257211dividers
diviner11369881diviner_
divines113514721divine_s
definers124211192definers
devisers12339862devisers
diners75525952d__iners
dinners83915442di_nners
disinters1039712disinters
divers105024962div__ers
divider12278952divider_
divides123211452divide_s
divine103514462divine__
divined12329692divine_d
divinely1544992divinely
divinest123012172divinest
divisors12255692divisors
drainers92811252drainers
liveners11217932liveners
liviers104211072livi_ers
advisers12135003advisers
airiness8412213airiness
airliners945983airliners
aivers94822323aiv__ers
aliners74717723_aliners
biners85023633__biners
bivinyls1641873bivinyls
bovines12412663bovine_s
briners94315633_briners
byliners1334753byliners
cavilers1348113cavilers
civies114116443civi_e_s
civilness1444223civilness
coiners93620753_coiners
daikers124010313d_aikers
dailiness1038673dailiness
damners104112113d_amners
darners83815773d_arners
davies105020513davi_e_s
deboners11268113deboners
deciders123510753deciders
decliners12358613decliners
defiers113913993defi_ers
defilers12439473defilers
definer114413773definer_
defines114118683define_s
deicers103612733d_eicers
deifiers12348993deifi_ers
delivers123310753delivers
deniers84515183deni_ers
deriders102411853deriders
deringers1137183deringers
derivers123811363derivers
designers1136003designers
desirers939263desirers
detainers10269103detainers
devices133212583device_s
devisees12358283devisees
deviser114212393deviser_
devises114116763devise_s
devisors12347253devisors
dewiness1238453dewiness
dialers83614303di_alers
diallers957773diallers
diamines11311643diamine_s
diapers104713913di_apers
diasters92913183diasters
diazines1838713diazine_s
dibbers124013173di_bbers
dibblers13377583dibblers
dicers94720743d__icers
dicier94416233dici_er_
dickers144117663di_ckers
diddlers11359153diddlers
didies84621833didi_e_s
dienes75719903di_ene_s
diesinkers1552783diesinkers
diesters92513603diesters
dieters83216433di_eters
diethers1257453diethers
differs14339973di_ffers
diggers104413393di_ggers
dikers114418793d__ikers
dilaters92513063dilaters
diluters9288113diluters
dimers94321093d__imers
dimeters11411093dimeters
dimmers123811563di_mmers
dimness1038843di_mness
dinars75417563d__inars
diner65632903d__iner_
dinero75612643d__inero
dineros83812333d__ineros
dines66449153d__ine_s
dingers94321383di_ngers
dinginess1137823dinginess
dinner74217163di_nner_
diopters1137693diopters
dipnets10109033di_pnets
dippers123615183di_ppers
dippiness1435973dippiness
direness9311303direness
dirtiness1039473dirtiness
disinter9310673disinter_
dislikers14286423dislikers
ditchers143610363ditchers
dithers114016153di_thers
ditsiness1048143ditsiness
ditziness1945883ditziness
divans104612393divan__s
diver94827803div__er_
diverse11429993div__erse
divert103922813div__ert
diverters13227873diverters
diverts114412033div__erts
dives95832403div__e_s
divide113410893divide__
divided13378593divide_d
dividend14284713dividend
dividends15273313dividends
diving113717953divin__g
divining1338413divining
divinise1267143divinise
divinises1367013divinises
divinity1546163divinity
divinize2197163divinize
divinizes2266673divinizes
divisor11345573divisor_
divorcers1543693divorcers
divulgers1442433divulgers
divvies1457663divvie_s
dizziness1834183dizziness
domineers1244673domineers
domines102918973domine_s
dopiness11289973dopiness
downers113912773d_owners
doziness18228553doziness
drainer83012843drainer_
driers74516733d_ri_ers
drinkers13277823d_rinkers
drivelers1364223drivelers
drivers114412793d_rivers
drivings13265763drivin_gs
droners84114383d_roners
drowners12428273drowners
duikers12369383d_uikers
dwines105013103d_wine_s
edifiers12336673edifi_ers
eloiners8128153eloiners
enviers1036993envi_ers
eveners10109503_eveners
fivers124420923fiv__ers
gainers84214593_gainers
ginners84314223gi_nners
givers104817713giv__ers
grainers93012073grainers
iciness938863_iciness
imines84918353_imine_s
inners63919353_i_nners
inviters11359643inviters
ironers74813553_ironers
ivies84215763_ivi_e_s
jivers164515643jiv__ers
jivier16438613jivi_er_
joiners144211573_joiners
leviers103510343levi_ers
liminess10510643liminess
limiters10249333limiters
limners93311563li_mners
liners65428853__liners
livener10278943livener_
liveness112411393liveness
livers94927823liv__ers
lividness1344713lividness
livier97514593livi_er_
livings11408923livin_gs
livyers13365903liv_yers
loriners839963loriners
mariners103113863mariners
milliners11289953milliners
miners84126633__miners
minivers1337483minivers
miriness10310463miriness
misinfers1445483misinfers
misinters1138183misinters
oiliness8311563oiliness
olivines1137473olivine_s
ovines94614343_ovine_s
pavisers13387443pavisers
pilsners1035533pilsners
pinners93518603pi_nners
pipiness1238003pipiness
pitiers93812653piti_ers
pixiness1736093pixiness
raveners11309133raveners
ravines104220233ravine_s
refiners114713313refiners
repiners103913433repiners
revilers114011693revilers
revisers113511933revisers
revivers14389633revivers
ribiers9319753ribi_ers
riminess10510093riminess
ripeners1036833ripeners
rivers94626543riv__ers
riveters11228163riveters
riviera1035073rivi_era
rivieras1143583rivi_eras
riviere1036373rivi_ere
rivieres1136013rivi_eres
ruiners74213023_ruiners
savines104417633savine_s
seiners74219273_seiners
shiners104015943_shiners
signers84714443si_gners
sinners74019023si_nners
sivers95324153siv__ers
siziness1737423siziness
stainers83212173stainers
tidiers8389773tidi_ers
tidiness938793tidiness
tininess8310633tininess
tinners73717313ti_nners
trainers83114643trainers
twiners10459633_twiners
veiners104112523_veiners
viers85621953__vi_ers
vinery124912603__vinery
vines85137643__vine_s
vintners1134573vintners
vipers114914533__vipers
visiters1137413visiters
vivers124717363__vivers
vivider14265623vivider_
vividness1643933vividness
vivifiers1843673vivifiers
viziers19336203vizi_ers
waviness1437723waviness
weiners103913063_weiners
whiners134011573_whiners
wideners12257993wideners
wieners103212483wi_eners
wiliness1139113wiliness
winners104316913wi_nners
wiriness1138953wiriness
wivers125320803wiv__ers

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.403443402.0
2DLD Change Limit1461622466.78321548.3
3Display Results2462460.0932645.2
 (SQL Overall)1786912467.27924548.8
 
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.