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

130 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
romaji153489(None) 
romajis1635911romajis
roman75424822roma_n
romano84912942romano
romans84620242romans
rumaki1235132rumaki
abomasi11115493abomasi
aroma71220143aroma__
aromas81018613aroma_s
aromatic12315643aromatic
bonaci10310963bonaci
bromal10313653broma_l
bromals1139743bromals
bromate11313553bromate
coati75624643co_ati
coma87134853coma__
comade114415323comade
comae97128423coma_e
comake144413423comake
comal95125133coma_l
comas95833003coma_s
comate104124843comate
comatic131816943comatic
comatik15139723comatik
domain9511323domain
domal85619203doma_l
fromage1336753fromage
gomuti936553gomuti
haji148520193__haji
homage121210603homage
koji155611123ko__ji
komatik12135203komatik
korai97018523kora_i
magi76329533__magi
maxi137023563__maxi
momi87524483mom__i
noma67529463noma__
nomad86016183noma_d
nomadic1248033nomadic
nomads94711603nomads
nomas74726413noma_s
nomoi76012533nom_oi
okapi1136613_okapi
omasa749483_omasa
oorali6311263oorali
pomace123111913pomace
pomade113611333pomade
ragi56032283r__agi
rai37658223r__a_i
raj105740223r__aj_
raja117918683r__aja
raki87127833r__aki
ramada9310183ramada
ramal74622243rama_l
ramate83921693ramate
rami66034093r__ami
rani46640113r__ani
remade94316983remade
remail85017123remail
remain85919863remain
remake124016113remake
reman75730153rema_n
remand95618963remand
remans84823003remans
remap95418103rema_p
remaps105012873remaps
remark123512373remark
remate84428683remate
rhombi13365203rhom_bi
roach105717003ro_ach
road56332113ro_a_d
roadie72813813ro_adie
roads66523623ro_ads
roam67132413ro_a_m
roamed95215093roamed
roamer84715163roamer
roams74919613ro_ams
roan47234203ro_a_n
roans54926443ro_ans
roar46328573ro_a_r
roars55622243ro_ars
roast56230143ro_ast
robalo838933robalo
roband92310723roband
rodman949713rodma_n
rom59855633rom___
romaine9512123romaine
romance11311083romance
romanise10312133romanise
romanize19311013romanize
romanos94311483romanos
romantic1249243romantic
romaunt947803romaunt
romeo73719703rom_eo
romeos84013173romeos
romp85926573rom__p
romped114513653romped
romper104213683romper
romps94617543rom_ps
roms67038963rom__s
rosaria749253rosaria
rosary92810353rosary
roshi8310753ro_shi
rota45834343rota__
rotary92411303rotary
rotas54827723rota_s
rotate63320343rotate
roti46332933ro__ti
rowan85418733rowa_n
rowans95715343rowans
royal85014703roya_l
royals93711263royals
rubati8299693rubati
rumakis1335533rumakis
soma65635293soma__
soman75024903soma_n
somans84619303somans
somas76030373soma_s
somata8312383somata
somatic111916473somatic
somoni8310743somoni
souari6311383souari
tamari8313413tamari
toman75724053toma_n
tomans85419133tomans
tomato8313453tomato
umami939883_umami
woman105818003woma_n
womans114613653womans
zombi1838993zom_bi

Search took 6 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 Filter1786911127160.420425454.8
2DLD Change Limit1127161305.37620966.5
3Display Results1301300.0462826.1
 (SQL Overall)1786911305.84230587.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.