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

194 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
pirogi929901(None) 
pierogi1054721pierogi
pirog83913671pirog_
piroghi13303841piroghi
pirogen1038262pirogen
pirogies1139422pirogies
pirogue1045412pirogue
pirojki2041272pirojki
prog75729002p_rog_
progs86624152p_rogs
aioli5318313ai_oli
ariosi64313033ariosi
biog76122323bi_og_
biogs85016113bi_ogs
biro66131213biro__
biros75325133biro_s
caroli85918233caroli
cirri7710723cir_ri
corgi8316083cor_gi
croci95818133_croci
dirge75117073dir_ge
epigoni1056093epigoni
epilog976463epilog_
epilogs1076583epilogs
frog85624363_frog_
frogs96220773_frogs
giro55828633giro__
giron66118993giro_n
girons75014373girons
giros65722653giro_s
grog65923343_grog_
grogs76319413_grogs
iroko939663_iroko
iron46728463_iro_n
irone55126363_irone
ironic8313773_ironic
irons55324133_irons
irony85015903_irony
liri45128253lir__i
lirot5430033liro_t
liroth938383liroth
mirage92313653mirage
miri66730373mir__i
neroli61111153neroli
padroni10278613padroni
pardi85723953par_di
parge85831853par_ge
pargo86723723par_go
pargos95719043pargos
parodic122311723parodic
parodoi10267723parodoi
parody12410093parody
parol74826273paro_l
parole84425253parole
parols84722613parols
parotic112518043parotic
parotid102915513parotid
parous84024163parous
peri65636973per__i
periti8319953periti
peroxid17310273peroxid
peroxy1838253peroxy
pibroch1643803pibroch
picolin11310883picolin
picot95031013pico_t
picots104616443picots
pidgin10259813pi_dgin
pierogies1245873pierogies
pig65744973pi__g_
piggie103210773pi_ggie
piggin103111093pi_ggin
piggy124011433pi_ggy
pignoli1045443pignoli
pigout9314613pigout
pigs76634223pi__gs
piing85218833piing_
piki106520563pi__ki
pilei74021783pi_lei
pili66130353pi__li
pilose84514243pilose
pilot77435063pilo_t
pilots84018873pilots
pilous84717753pilous
ping75943593pi_ng_
pingo87122713pi_ngo
pingos95317673pingos
pings85830883pi_ngs
pinole83218783pinole
pinon76024533pino_n
pinons86019943pinons
pinot78737293pino_t
pinots85920273pinots
pion67235293pi_o_n
pionic103515953pi_onic
pions75826393pi_ons
pious74621273pi_ous
pipage1199143pipage
piracy1339473piracy
piragua1044643piragua
pirana8713263pirana
pirate82322883pirate
piratic11314293piratic
piraya1167713piraya
pirn67128373pir__n
pirns76020093pir_ns
pirogues1135473pirogues
piroque1844353piroque
piroshki1741713piroshki
pirozhki2651023pirozhki
pishoge1336693pishoge
piso66727563piso__
pisos76021063piso_s
piton76121583pito_n
pitons85319043pitons
pivot106523873pivo_t
pivots115111903pivots
pogy105623553p__ogy
poi57244663p__o_i
poori74816233p_oori
porgy116916123por_gy
porose84818743porose
porous84419483porous
priapi1037923priapi
prig75924873p_rig_
prigs85219703p_rigs
primi95017403p_rimi
prion75119993prio_n
prions84317783prions
prior74316173prio_r
priors83914483priors
priory114110263priory
pro55837263p_ro__
proa66229963p_ro_a
proas75028803p_roas
probe94320813p_robe
probit103218353p_robit
prod76129503p_ro_d
prods85523553p_rods
proem94818273p_roem
prof96134663p_ro_f
profit113016273p_rofit
profs105120893p_rofs
progun968783p_rogun
prole74527793p_role
prolix1538683p_rolix
prom87631703p_ro_m
promo95620003p_romo
proms95426413p_roms
prone75332623p_rone
prong85218113p_rong
prongs94314483p_rongs
proof105221533p_roof
prop85932813p_ro_p
props95726883p_rops
pros65742783p_ro_s
prose75835123p_rose
prosit85124593p_rosit
proso77222413p_roso
pross76529403p_ross
prost75434103p_rost
prosy106319253p_rosy
protei82615313p_rotei
proud84615483p_roud
prove104823193p_rove
prow97030383p_ro_w
prowl105615123p_rowl
prows106327013p_rows
proxy175011013p_roxy
psoai7469923p_soai
purge85324603pur_ge
puri65931443pur__i
pylori1147163pylori
pyro96019393pyro__
pyrogen1337353pyrogen
pyrola1139003pyrola
pyrone112714473pyrone
pyrope132810533pyrope
pyros105718293pyro_s
pyrosis12411653pyrosis
ragi56032283__ragi
roti46332933__roti
shogi95014013_shogi
spiroid10219823spiroid
tiro46832363tiro__
tiros54524893tiro_s
tragi64717173_tragi
trog57628213_trog_
trogs67022603_trogs
virago1046643virago
virga9310253vir_ga
virgin1038083vir_gin
viroid10411523viroid
virosis1039023virosis
yogi86120423__yogi

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.393454684.5
2DLD Change Limit1127161945.04622337.7
3Display Results1941940.0464217.4
 (SQL Overall)1786911945.48532578.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.