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

117 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
pembina134522(None) 
pembinas1454141pembinas
semina8915572sem_ina
amboina1137963_amboina
bambini1336583bambini
bambino1336483bambino
bombing143211393bombing
cambia124913153cambi_a
combine133014723combine
combing143714733combing
corbina111911453corbina
cumbia12379893cumbi_a
demoing11311753demoing
dumbing13319853dumbing
ebbing1137073_ebbing
embank14346553_embank
encina8310443_encina
gambia115912253gambi_a
geminal10109913gem_inal
gemming13289153gemming
germina1038503germina
hemin103620933hem_in_
hemins113417573hem_ins
hemline12311073hemline
hemming15269973hemming
jambing19328533jambing
kerbing14308483kerbing
lambing123412413lambing
lamina84920443lam_ina
lemming12269393lemming
lempira1144193lempira
lesbian944463lesbian
limbing123410423limbing
limina83514503lim_ina
lumina84613543lum_ina
mbira977973__mbira
medina94114093me_dina
mina65136923__m_ina
nomina83113683nom_ina
numbing12269033numbing
numina83510843num_ina
pastina93914593pastina
patina86022193p_atina
peacing124117073peacing
peaking144317693peaking
pealing104123203pealing
pebbling1535073pebbling
peching154513903peching
pecking164017783pecking
pectin102615533pectin_
pectins112315233pectins
peeing94618083pe_eing
peeking144414953peeking
peeling102919873peeling
peening103318303peening
peeping123615213peeping
peering103520353peering
peeving135112243peeving
pegging122811133pegging
pein65834943pe__in_
peining104619153peining
peins76128063pe__ins
peising103416763peising
pekin111514423pe_kin_
pekins121812233pe_kins
pelting102917273pelting
pemican1348163pem_ican
pemmican1643053pemmican
pemoline12310273pemoline
pending114119773pending
penna74520203pe__nna
pennia84412973penni_a
pennine93712953pennine
penning103616493penning
pepino10310333pe_pino
pepping113511623pepping
pepsin10310853pepsin_
pepsine11310603pepsine
pepsins11310433pepsins
pereia85217983perei_a
perinea9313033pe_rinea
perking143716463perking
permian112612283permian
perming123416093perming
persona92812453persona
petting103720953petting
petunia966803petunia
phobia13278603phobi_a
pimping143812123pimping
pina65842633p___ina
piscina1177043piscina
platina94413643platina
plumbing15286433plumbing
prebind123810643prebind
probing123314443probing
pumping144213553pumping
pyemia1337553pyem_i_a
rebind94416933re_bind
regina75317143re_gina
remain85919863remain_
remains94117913remains
remind94819793rem_ind
remint85329983rem_int
retina65023383re_tina
retsina74710603retsina
rumina83412483rum_ina
seminal91213413sem_inal
seminar979763sem_inar
semolina1047493semolina
sestina72711973sestina
tegmina1035243tegmina
temping122710693temping
terbia8311153terbi_a
tombing123310533tombing
verbena1235373verbena
vimina11339943vim_ina
webbing1536123webbing

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271176.59320328.7
3Display Results1171170.0303900.0
 (SQL Overall)1786911177.02925422.0
 
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.