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

242 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
regainer924935(None) 
regained102111241regained
regainers10237381regainers
retainer82913811retainer
detainer92910792detainer
gainer74117492__gainer
recliner103211912recliner
redliner93510472redliner
refiner105316912re_finer
refrainer1245842refrainer
regain74517762regain__
regains84316582regain_s
regaler83814622rega_ler
regather1236732regather
remainder1244682remainder
remained112412892remained
repairer1036782repairer
repiner94816902re_piner
retailer82911572retailer
retained93016092retained
retainers92510762retainers
attainer8116913attainer
bargainer1244563bargainer
beginner1173953beginner
beguiler1154063beguiler
beguine1068503beguine_
beguines11127213beguines
betaine9413783betaine_
betaines10313293betaines
bewailer1334863bewailer
certainer1146193certainer
decliner113710843decliner
definer114413773de_finer
degasser10325813degasser
delaine8314793delaine_
delaines9312963delaines
detailer9268673detailer
detained103111643detained
detainee92511723detainee
detainers10269103detainers
drainer83012843_drainer
dreggier1193553dreggi_er
earner63617223_e_arner
eloiner7149183_eloiner
examiner17145463_examiner
fainer94717243__fainer
gained84617463__gained
gainers84214593__gainers
gaiter73819503__gaiter
garner73917003__garner
grainer83714063_grainer
gregarine1144783gregarine_
gregarines1244783gregarines
imaginer1144303imaginer
jetliner1534853jetliner
leaner64022193le_a_ner
learner7319383le_arner
legalizer1946323legalizer
legatine91311403legatine_
leggier9368233leggi_er
meaner84617843me_a_ner
negater83711963nega_ter
obtainer1045793obtainer
ordainer945223ordainer
plainer93811983_plainer
prevailer1445153prevailer
raider74318743r__aider
railer64524933r__ailer
rained75024603r__ained
rainier71614263r__ainier
raiser66620103r__aiser
reacher123718293re_acher
reader73628293re_a_der
readier83117423re_adier
reagin74915533reagin__
reaginic1144453reaginic
reagins84215643reagin_s
realer63528593re_a_ler
realiser82512563realiser
realizer172412113realizer
realter73716313re_alter
reamer84325213re_a_mer
reannex1434733re_annex
reaper84223143re_a_per
rearer64928913re_a_rer
reasoner849343reasoner
reaver94524733re_a_ver
rebaited11410543rebaited
rebater93517913reba_ter
recaller1039323recaller
recamier1237603recamier
recane83022873reca_ne_
recaned102817203reca_ned
recanes93222263reca_nes
recanter101913153recanter
receiver1337413receiver
reciter94117263re_citer
reckoner1446063reckoner
reclaimer1344463reclaimer
recline94020493recline_
reclined113613603reclined
recliners11279113recliners
reclines103718543reclines
recoiler103210493recoiler
recoined113614423recoined
redbaiter1244153redbaiter
redline84218833redline_
redlined103811233redlined
redliners10267853redliners
redlines93916083redlines
reearned948883reearned
reedier83815303reedi_er
reefier102912553reefi_er
reekier113111123reeki_er
refine95225693re_fine_
refined114720003re_fined
refiners114713313re_finers
refinery14447193re_finery
refines105426343re_fines
refrained1347223refrained
refrainers1344473refrainers
regaining112411083regaining
regale74821453rega_le_
regaled93615963rega_led
regalers94311133rega_lers
regales83520793rega_les
regaling10315363regalin_g
regalness1045473regalness
regarded11279803regarded
regathers1336353regathers
regauge945813regauge_
regauged1135143regauged
regauges1046093regauges
regave104713383rega_ve_
regime95313943reg_ime_
regimen104411573reg_imen
regimes104514743reg_imes
regina75317143reg_in_a
reginae84713453reg_inae
reginal84814293reg_inal
reginas85614063reg_inas
register939553register
regive104814323reg_ive_
regiven11478323reg_iven
regives115014213reg_ives
regrind938983regrin_d
regrinds1035533regrinds
reguline939503reguline_
rehabber1563153rehabber
rehammer1544653rehammer
reifier103414523reifi_er
reined74425523re__ined
reinter73116843re__inter
reiver95318293re__iver
rejoicer17315343rejoicer
rejoinder1743713rejoinder
rejoined16318593rejoined
relapser1035273relapser
relater73723143rela_ter
relaunder1053703relaunder
relaxer143410223rela_xer
relier65826183re_li_er
reline65434353re_line_
relined85321933re_lined
relines75331323re_lines
remailed112411403remailed
remain85919863remain__
remainders1354023remainders
remains94117903remain_s
remaker133813173rema_ker
remanned11319353remanned
remarker14178493remarker
remaster10311473remaster
reminder113110513re_minder
renailed92512803renailed
rentier73618223renti_er
repaint9318363repain_t
repainted1277863repainted
repaints1038483repaints
repair84011463repai__r
repaired1148953repaired
repairers1135283repairers
repanel939963repa_nel
repaper11310023repa_per
repine85627813re_pine_
repined104918773re_pined
repiners103913433re_piners
repines94927383re_pines
replier94214973repli_er
reprinter1197353reprinter
requirer17156113requirer
requiter17168643requiter
reraise7316313reraise_
reraised9312353reraised
reraises8415643reraises
resailed93613063resailed
rescinder1245293rescinder
reshine102816943reshine_
reshined123011123reshined
reshines112615443reshines
resider84615803re_sider
resigner937793resigner
resined84522653re_sined
restrainer1046973restrainer
retailed94113963retailed
retailers9258773retailers
retailor8285223retailor
retain64523283retain__
retains74522253retain_s
retaker113714313reta_ker
retarder9229433retarder
rethinker1643613rethinker
retine66237333re_tine_
retines75134673re_tines
retirer74715013re_tirer
retrained10411313retrained
retrainee9511163retrainee
returner8397983returner
reuniter838323reuniter
revamper1533533revamper
reviler104314973re_viler
reviser104114663re_viser
reviver134411373re_viver
rewarder12208233rewarder
rewinder12317663re_winder
rewriter1137923rewriter
rexine134719443re_xine_
rexines144719153re_xines
romaine9512123romaine_
romaines10512523romaines
ruiner64013643r__uiner
seiner64622483se__iner
semainier1144753semainier
stainer73614923_stainer
strainer8512223strainer
trainer73316793_trainer
trepanner1143523trepanner
vainer93714573__vainer
veiner94514753ve__iner
weaner93816773we_a_ner
weiner94214133we__iner
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.1561145455.1
2DLD Change Limit1461622427.42319690.4
3Display Results2422420.0932602.2
 (SQL Overall)1786912427.67223291.3
 
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.