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

158 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
sugarier93739(None) 
sugarer837321sugar_er
scarier94017872s_carier
smearier1036952smearier
sudaries9312752sudaries
sugared938582sugar_ed
sugarers936302sugar_ers
sugariest1038132sugariest
sugaring1039052sugaring
sultrier837772sultrier
angaries9314393angaries
angrier839023ang_rier
augurer8136343augur_er
auguries947933auguries
blearier1037333blearier
buggier113611343bug_gier
burier84324653bu__rier
burrier93613553bu_rrier
charier124317903_charier
currier93316703cu_rrier
drearier9297923drearier
fuggier12348963fug_gier
furrier103513663fu_rrier
gamier93617933__gamier
garner73917003__garner
garter74420513__garter
glarier84112203_glarier
gorier73719373__gorier
guarder936463gu_arder
hoarier104211743_hoarier
hungrier1233893hungrier
hurrier103412943hu_rrier
learier73415663_learier
muggier11288943mug_gier
pugaree10208033pugar_ee
pugarees11195493pugarees
puggier11309383pug_gier
puggries12166383puggries
quaggier1933853quaggier
quakier20239203qu_akier
quarrier1736843quarrier
quarter163211853qu_arter
quartier1737543qu_artier
queasier1734473queasier
queazier2642833queazier
querier16310013qu_erier
safaried1236253safaried
saggier92912063sag_gier
sagier73717163s__agier
salaried9311023salaried
salaries8319573salaries
sarkier113413313s__arkier
savorier1136643savorier
scalier94316913s_calier
scarcer113911373s_carcer
scarer84524613s_car_er
scarfer124511083s_carfer
scarper114814823s_carper
scarrier10298453scarrier
seamier93114633s_eamier
searer65432023s_ear_er
shadier113111153s_hadier
shaggier13116053shaggier
shakier143411153s_hakier
shalier103116423s_halier
sharer95025483s_har_er
sharker144313813s_harker
sharper124312703s_harper
shearer104414683shear_er
shoalier1137073shoalier
slaggier10126953slaggier
slatier74016813s_latier
sleazier1735123sleazier
smarmier1235033s_marmier
smarter94113133s_marter
smearer94110403smear_er
snaggier10136303snaggier
snakier112810003s_nakier
snarer64620843s_nar_er
snarkier12336513s_narkier
snarler73610633s_narler
snarlier8278183s_narlier
sneakier1245143sneakier
sneerier878103sneerier
soapier93411713s_oapier
soarer64522243s_oar_er
soggier93410883sog_gier
sorrier72313733s_orrier
spacier114011633s_pacier
sparer84524963s_par_er
sparger103613083s_parger
sparker133914363s_parker
sparkier14298033s_parkier
sparrier10329143sparrier
sparser94311483s_parser
spearer93913663spear_er
spherier1337783spherier
spirier93214073s_pirier
sprier84119063s__prier
spurrier10297693spurrier
squarer163410663squar_er
squeakier2242903squeakier
staggier10167513staggier
stagier83513443s_tagier
starer64027363s_tar_er
starker114114693s_tarker
starrier8279463starrier
starter73817883s_tarter
starver104611993s_tarver
steadier937313steadier
steamier1048303steamier
strawier1137493strawier
suaver93014233su_a_ver
subarea939403subar_ea
subarid10310653subari_d
submariner1444073submariner
suborder1146663suborder
suborner1047383suborner
subwriter1445623subwriter
suckier133613973su_ckier
sudaria847973sudari_a
sudarium1145523sudarium
sudsier868783su_dsier
sugar6312913suga___r
sugarberry1651363sugarberry
sugarless1043673sugarless
sugarlike1443243sugarlike
sugars7312423sugar__s
sugary1039013sugar__y
sulkier113811963su_lkier
summaries13118183summaries
summarizer23104273summarizer
summerier1346423summerier
sundries9312023sundries
sunnier73412153su_nnier
superber1239693superber
superior10310883superior
supplier1246603supplier
surer54833103su__r_er
surfer93515883su__rfer
surfier102613543su_rfier
surger74320093su__rger
surgeries10311363surgeries
surlier72915443su_rlier
surpriser1144613surpriser
swarmer1247803s_warmer
swearer10349953swear_er
sweatier1147033sweatier
tearier73815613_tearier
uglier748953_ug_lier
unwarier1136883unwarier
vagaries12310293vagaries
varier94619353__varier
vuggier12296813vug_gier
vulgarer1243013vulgar_er
vulgarizer23143763vulgarizer
warier93722893__warier
wearier103613283_wearier

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.440406115.9
2DLD Change Limit1461621586.59322169.3
3Display Results1581580.0602633.3
 (SQL Overall)1786911587.09325192.6
 
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.