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

181 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
vagrom123594(None) 
carom95025562ca_rom
carrom10513402carrom
pogrom1138592pogrom
varoom11411412varoom
aero45435343_aero_
aggro738013aggro_
aggros836553aggros
agio57828453_agio_
agios65919863_agios
agism84614063_agism
aglow94711973_aglow
ago48845523_ag_o_
agog68019003_ag_og
agon56531883_ag_on
agora6914333_agora
agorot7415003_agorot
agree65226033_agree
agria65517143_agria
anagram1058193anagram
apron7318833_apron
argol65317263_argol
argon65520593_argon
argot67728653_argot
arm58449623_a_r_m
aroma71220143_a_roma
arrow83414883_arrow
arum66129033_a_rum
atom67824523_a_tom
aurum7614963_aurum
axiom143913593_axiom
bagworm1566343bagworm
barm86739603ba_r_m
baron78131243ba_ron
barroom1139373barroom
barrow114512763barrow
begrim11118333begrim
cargo85322073cargo_
cargos94619183cargos
carob95325223ca_rob
carol75128613ca_rol
caroms105619573ca_roms
carroms11512403carroms
carrot8423123carrot
dacron94310693dacron
dago65725093dag_o_
dagos76419443dag_os
dayroom1345233dayroom
diagram1147363diagram
dogdom1186363dogdom
eagre64315323eagr_e
eagres74014573eagres
engram9310653engram
faggot1139053faggot
fagot9323403fag_ot
fandom122110893fandom
fantom112110803fantom
farm95934533fa_r_m
faro76136923fa_ro_
faros85532023fa_ros
farrow12309973farrow
fathom1437473fathom
from96923923__from
garron73113493garron
glom75424383__glom
gorm75529393__gorm
gram77034583__gram
grim76929423__grim
grog65923343__grog
grok95819683__grok
groom85317983__groom
grot55942053__grot
grow86127303__grow
grum75625083__grum
hadron102913753hadron
hagdon1188283hagdon
hagrode1236443hagrode
hansom11219153hansom
harem104924453ha_rem
harm95637793ha_r_m
harrow122610773harrow
jagra1338173jagr_a
jagras1438463jagras
jargon1448823jargon
karoo92519583ka_roo
karroo10410013karroo
labrum1057423labrum
ladron73413323ladron
lagoon7410483lagoon
largo65319783largo_
largos74815063largos
larum74317973la_rum
legroom1076093legroom
macro94718173macro_
macron103615673macron
macros104017013macros
madtom1138023madtom
maggot10311713maggot
magnum1136733magnum
magot8326393mag_ot
marram10313883marram
marron83717543marron
marrow112812603marrow
matron83918313matron
megrim1178043megrim
narrow9269143narrow
natron64116023natron
pagod95013683pag_od
pangram1239023pangram
pargo86723723pargo_
pargos95719043pargos
parol74826273pa_rol
parrot8320663parrot
patrol83213023patrol
patron84018043patron
pogroms1237643pogroms
prom87631703__prom
ragtop936683ragtop
ramrod936833ramrod
random92513553random
ransom82410943ransom
regroom1077293regroom
regrow10309883regrow
rom59855633___rom
sacrum103910143sacrum
safrol937283safrol
sago56332673sag_o_
sagos66123873sag_os
sagum8512873sag_um
sargo65424413sargo_
sargos74318273sargos
sarod65325873sa_rod
saros55238063sa_ros
tagrag837043tagrag
tangram1038073tangram
taproom1147963taproom
taro46846913ta_ro_
taroc75721643ta_roc
tarok97921073ta_rok
taros55640823ta_ros
tarot55943933ta_rot
upgrow1234273upgrow
vacuum1334833vacuum
vagal94613633vag_al
vagary1337333vagary
vagi86719363vag__i
vagile10310543vagile
vagina102710933vagina
vagotomy1742163vagotomy
vagrant11410663vagrant
vague96513113vag_ue
vaguer10448443vaguer
vagus96713813vag_us
vair75624143vair__
vairs85019133vair_s
valor83614893va_lor
valors93413773valors
vapor104013093va_por
vapors113812693vapors
vapory14398763vapory
var66148333va_r__
vara75530883va_r_a
varas86028193va_ras
varia85824203va_ria
varix154313513va_rix
varna84516173va_rna
varooms1248883varooms
vars75742073va_r_s
varus85921183va_rus
varve115716853va_rve
vary105226063va_r_y
venom103914863v_enom
vigor92612423vig_or
vigors102911483vigors
vroom105312473v_room
vrow105817473v__row
waggon1136393waggon
wagon94312953wag_on
wagsome1345213wagsome
warm95935673wa_r_m
yarrow12287933yarrow

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.390458182.1
2DLD Change Limit1127161815.36021029.1
3Display Results1811810.0463934.8
 (SQL Overall)1786911815.79630830.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.