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

207 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
pomelos1121813(None) 
pomelo10238661pomelo_
pumelos11196091pumelos
comedos12329072comedos
polos76129912po__los
pomes94833932pome__s
pommels13235782pommel_s
pomos95321582pom__os
pumelo10257112pumelo_
pummelos14223102pummelos
romeos84013172rome_os
apollos946793apo_llos
boleros9310293boleros
bolos75531373bo__los
botels84815803botel_s
bowels114315593bowel_s
camels105217083camel_s
cameos105818003came_os
coelom10310433co_elom
coeloms1139063co_eloms
combos125316613com_bos
comedo11359603comedo_
comely134213733comel_y
comers105328083come_rs
comes97246993come__s
comets105823583come_ts
compels133210883compel_s
complot13310683complot
complots1438163complots
compos124818803com_pos
cormels113813373cormel_s
domes85735563dome__s
dominos103210193dominos
dowels104813343dowel_s
foments122912053foments
gimels938893gimel_s
gombos114311093gom_bos
gomers94116883gome_rs
helos84928063__helos
hollos95320633ho_llos
homeboy1746153homeboy
homeboys1845513homeboys
homeless131110133homeless
homely145313173homel_y
homers114821973home_rs
homes106938813home__s
homeys145012873home_ys
hommos13128503hom_mos
homolog1346963homolog
homologs1448233homologs
homos105921783hom__os
hosels94218603hosel_s
hotels94515513hotel_s
hovels125413333hovel_s
koels94613903ko_el_s
kolos94921213ko__los
lomeins969473lomeins
loments93413473loments
losels64714583losel_s
melds84822383__melds
mells75031333__mells
melon73922083__melon
melons84117713__melons
mels65941533__mel_s
melts74930103__melts
memos95719113__memos
milos75428013__milos
mimeos104511543mime_os
models94216353model_s
mohels115011323mohel_s
momentos12338333momentos
moments113113123moments
momes95134473mome__s
morellos10136953morellos
morels84820013morel_s
motels83616893motel_s
noels56418703no_el_s
nolos54423353no__los
nombles113212343nombles
nomes74933123nome__s
nomos75919743nom__os
nonegos837143nonegos
novels95512503novel_s
obelus8348403_obelus
ocelot8813383_ocelot
ocelots977233_ocelots
oleos55419683_ole_os
omegas936973_omegas
omelet8317073_omelet
omelets938333_omelets
omens75618963_ome_ns
omers76923193_ome_rs
ovolos9257203_ovolos
pamperos14306693pamperos
panels84716523panel_s
pareos87023773pare_os
paseos88015813pase_os
pedalos10329703pedalos
peels75226423p_eel_s
peles75738083p__eles
pelfs105016293p__elfs
pelon74423213p__elon
pelts76128813p__elts
peplos101211543p_eplos
pepos96620083p__epos
pesos77221623p__esos
phyllos1535583phyllos
pimentos1246233pimentos
pimples133012423pimples
pixels15478533pixel_s
podsols1056513podsols
podzols1934683podzols
poems95715553po_e_ms
poets76024443po_e_ts
pogeys124110353poge_ys
poilus82210573po_ilus
pokers124617923poke_rs
pokes116133013poke__s
pokeys15529513poke_ys
poleis86018353pole_is
poleless1089873poleless
polers84225643pole_rs
poles75351003po__les
poleyns1236113poleyns
polios84019723po_lios
polis74731163po__lis
pollees93215333pollees
pollens93713303pollens
pollers93420023pollers
polls74627723po__lls
polo66236633po__lo_
pols66044563po__l_s
polyols1238493polyols
polys105718763po__lys
pomaces132712123pomaces
pomades123711733pomades
pome85636693pome___
pommel12277453pommel__
pommeled1543103pommeled
pommies133712843pommies
pomo85828453pom__o_
pomology1637193pomology
pompanos1445243pompanos
pompom1436493pom_pom
pompoms1535333pompoms
pompon1238943pom_pon
pompons1338553pompons
pompous1338063pompous
pomps115316193pom__ps
poms87037743pom___s
ponchos143410703ponchos
pones74547043pone__s
poodles103013513poodles
poolers94217423poolers
pools74427703po_ol_s
poos65949113po___os
popedom1445453popedom
popedoms1545283popedoms
popeless1288473popeless
popes95933813pope__s
popples103011873popples
populous1245953populous
pores75849033pore__s
pornos85015253po_rnos
posers84223973pose_rs
poses74642763pose__s
poseurs9378293poseurs
posoles9314883posoles
poteens92910883poteens
pothos114214693po_thos
pottles93816983pottles
pottos84615873po_ttos
poults84613483po_ults
powers113822323powe_rs
poxes145325723poxe__s
pozoles1839063pozoles
primeros12336883primeros
promos105116423prom__os
propels113412843propel_s
pueblos1134843pueblos
pummelo13284233pummelo_
pummels13236543pummel_s
remelts93511493remelts
robalos937683robalos
rodeos75314503rode_os
romanos94311483romanos
romeo73719703rome_o_
rowels94515453rowel_s
smells83914743_smells
smelts85412773_smelts
solos54830793so__los
somehow1543663somehow
sorels63921163sorel_s
telos55424523__telos
toledos8388863toledos
tombolos1245113tombolos
tomes76037383tome__s
toreros7311343toreros
towels94314643towel_s
tupelos936113tupelos
vomers115614943vome_rs
vomitos12217103vomitos
vowels124410483vowel_s
womeras1287593womeras
yodels104610073yodel_s
yokels13488063yokel_s
zocalos1835393zocalos

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.423422437.4
2DLD Change Limit1340272077.01619103.1
3Display Results2072070.0633285.7
 (SQL Overall)1786912077.50223819.1
 
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.