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

300 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
decriers1129973(None) 
decreers11277621decreers
decrier102713551decrier_
decries103319801decrie_s
descriers1245691descriers
criers83918582__criers
dearies83526272dearie_s
debriefs1433532debriefs
decayers14307962decayers
deceivers1535722deceivers
deciders123510752deciders
deckers144413832dec_kers
decliners12358612decliners
decoders122810412decoders
decoyers14287712decoyers
decreer10269122decreer_
decrees102513122decr_ees
decrials1137132decrials
decried112612852decrie_d
decuries11312222decurie_s
defiers113913992de_fiers
deifiers12348992deifiers
deniers84515182de_niers
deprivers1545212deprivers
deriders102411852de_riders
derivers123811362de_rivers
derriere936042derriere
derrieres1044812derrieres
derries83124622derrie_s
describers1543582describers
descrier1157622descrier_
descries11311922descrie_s
desirers939262desirers
destriers1038142destriers
driers74516732d__riers
terriers84210812terriers
aerier64823153ae_rier_
aeries64737783ae_rie_s
barriers104311883barriers
bearers94619593bear_ers
becrimes1467073becrimes
beerier93613023beerier_
beliers94617383be_liers
berries94423553berrie_s
briers85319733__briers
buriers94017193_buriers
carriers103614203carriers
couriers103213173couriers
crier74724463__crier_
cries75438403__crie_s
curriers103410753curriers
dackers143417043dac_kers
dairies84217733dairie_s
dalliers93610613dalliers
darers75921873d_ar_ers
darners83815773d_arners
darters84017603d_arters
deairs74013783de_ai_rs
dealers84118613de_alers
dearer74822803dear_er_
dearie73319813dearie__
dearness939973dearness
debarkers16164553debarkers
debasers11377903debasers
debaters113511923debaters
deboners11268113deboners
debrides1268723debrides
debrief1337623debrie_f
debriefers1641653debriefers
debris93311493debri__s
decades113615513decade_s
decaliters1345213decaliters
decanes103118913decane_s
decanters12229223decanters
decares102818533decare_s
decayer13339353decayer_
deceits102810883decei_ts
deceiver1436233deceiver_
deceives1437903deceives
decenters122410373decenters
decern91310953dec__ern
decerns10119053dec__erns
deciare10710663dec_iare
deciares11510633dec_iares
decibels1344523decibels
decider114213183decider_
decides114217653dec_ides
deciles104417723dec_iles
deciliters1345173deciliters
deciphers1744393deciphers
deckels14367363dec_kels
decker135215993dec_ker_
deckings16346683deckings
deckles143312803deckle_s
declaimers1543593declaimers
declarers1236423declarers
declares11611313declares
decliner113710843decliner_
declines113315803declines
decoder113712293decoder_
decodes113914983decode_s
decolors1187713decolors
decors94017773dec__ors
decoyer13348683decoyer_
decrease1136563decr_ease
decree93117783decr_e_e
decreed112710253decr_eed
decrial10310323decri_al
decrowns14265063decrowns
decrypts1642943decrypts
decurions1246023decurions
decurves1435863decurve_s
deedier93011593deedier_
deers64930523de___ers
defacers14237993defacers
defamers14258523defamers
deferrers13115153deferrers
defers105116943de__fers
defier105118653de_fier_
defies104624053de_fie_s
defilers12439473defilers
definers124211193definers
deforcers15265503deforcers
deformers15266533deformers
defrayers1644173defrayers
defusers12487363defusers
degraders12245933degraders
degrees92810723degr_ees
dehorners1344743dehorners
deicers103612733de_icers
deifier113013123deifier_
deifies113317453deifie_s
deities82621923deitie_s
delayers12268663delayers
delivers123310753delivers
dellies83622213dellie_s
deluders10156433deluders
delvers113411993de_lvers
demergers13146403demergers
demies94825803de_mie_s
demireps1343993demireps
demurrers1243713demurrers
dendrimers1442743dendrimers
denier74420693de_nier_
denies74729643de_nie_s
denuders10165873denuders
deporters1277793deporters
deposers11359243deposers
depravers1534683depravers
depress10239873depr_ess
depriver1446293depriver_
deprives1438393deprives
derbies103016053derbie_s
derider93214973de_rider_
derides93420853de_rides
deringers1137183de_ringers
deriver114213913de_river_
derives114017813de_rives
dernier83011943dernier_
derricks1544433derricks
derringers1243843derringers
derris73615273derri__s
derrises93012783derrises
describer1444613describer_
describes1446003describes
descried1248073descrie_d
deserters10129983deserters
deservers13107293deservers
desirer8310783desirer_
desires81316133desire_s
despisers1245153despisers
destrier9311823destrier_
detailers10257253detailers
detainers10269103detainers
detergers11147183detergers
deterrers10116593deterrers
deters74724683de__ters
detritus945473detritus
devisers12339863devisers
devoirs1175783devoi_rs
dewaters122910723dewaters
dewier104013463de_wier_
dewormers15255193dewormers
dexies145018343de_xie_s
diaries83321953diarie_s
dicers94720743dic__ers
dicier94416233dic_ier_
dickers144117663dic_kers
dickier143512453dickier_
dickies143416343dickie_s
dictier103411863dictier_
dockers143715003doc_kers
dories75232363d_orie_s
dormers104313913d_ormers
dorpers104113163d_orpers
dorsers83516293d_orsers
dossiers9318043dossiers
dowries114413983dowrie_s
drearier9297923drearier_
drearies92313413drearie_s
drier64423963d__rier_
dries64733673d__rie_s
drivers114412793d__rivers
dryers10449273d__ryers
duchies133312313duchie_s
duckers143214713duc_kers
duckier143911793duckier_
duckies143613813duckie_s
durries83817353durrie_s
earners74016453_earners
echoers12459693_echoers
edifiers12336673edifiers
eerier64320023_eerier_
enviers1036993_enviers
eyries93816813_eyrie_s
farriers113610743farriers
fearers104815273fear_ers
ferries103521083ferrie_s
friers94718933__friers
furriers11369493furriers
harriers113712433harriers
hearers104319783hear_ers
hecklers17357123hecklers
henries102718283henrie_s
herders113914123he_rders
herries104025073herrie_s
hurriers11358893hurriers
jeerers14328923jeer_ers
jerkers18287083je_rkers
jerries143817513jerrie_s
kerries113317913kerrie_s
learier73415663learier_
learners8398153learners
lechers123313963lec_hers
leerier73111503leerier_
leviers103510343le_viers
marriers103312473marriers
mercers114412773me_rcers
mercies113817563mercie_s
mergers103813423me_rgers
merrier92612303merrier_
metiers93312843me_tiers
neckers134210463nec_kers
parriers103612903parriers
pearlers1039033pearlers
peckers153312673pec_kers
peckier153910523peckier_
peeries93623023peerie_s
perchers153611523perchers
perries93226603perrie_s
priers84521193__priers
queriers1736963queriers
rearers74323563rear_ers
recamiers1345513recamiers
receivers1436363receivers
reciters102613113reciters
recliners11279113recliners
recoilers11318153recoilers
recorders12187953recorders
recovers133511123recovers
recruiters1243713recruiters
redries83721713redrie_s
refries104419733refrie_s
reifiers11309843reifiers
reliers75519213re_liers
rentiers83311763rentiers
reorders9198833reorders
repliers103710163repliers
retirers84311533retirers
retries74129073retrie_s
rewriters1236343rewriters
scribers12307953_scribers
scries85226823_scrie_s
seceders11277963seceders
secrets9311773secr_ets
securers1057153securers
sergers83815633se_rgers
series64540973se_rie_s
serries73925353serrie_s
servers103214833se_rvers
tarriers83411713tarriers
tearers75218233tear_ers
tearier73815613tearier_
techier1269243techier_
techies12513603techie_s
termers95414503te_rmers
terrier73414963terrier_
terries73425613terrie_s
triers64321523__triers
variers103712663_variers
veeries102916893veerie_s
vergers114412633ve_rgers
verier94620963ve_rier_
verniers11227843verniers
versers103813523ve_rsers
wearers104615903wear_ers
wearier103613283wearier_
wearies103020223wearie_s
worriers11257813worriers
yearners11346373yearners

Search took 9 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.1701051123.5
2DLD Change Limit1461623008.48617223.9
3Display Results3003000.1062830.2
 (SQL Overall)1786913008.76220393.9
 
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.