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

139 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
girolle83579(None) 
girolles935521girolles
girdle82110462gir_dle
girlie73711462gir_lie
grille74315742g_rille
airhole1048273airhole
binocle1136493binocle
birle75023633bir__le
brolly114510853_brolly
carolled1138833carolled
caroller1039203caroller
ciboule1145093ciboule
circle1039703cir_cle
citole8311503cito_le
corolla938623corolla
criollo943953criollo
dipole91112853dipo_le
droll65415403_droll_
drolled93810223_drolled
droller84110283_droller
drolls75312393_drolls
drolly105411673_drolly
enroll61110073enroll_
enrolled967963enrolled
enrollee878343enrollee
enroller867183enroller
enrolls7108093enrolls
fille84327403fi__lle
gabelle10259213gabelle
garble94118453gar_ble
gargle84215463gar_gle
gargoyle1342503gargoyle
garote7717953garo_te
garotte868703garotte
gazelle17236333gazelle
gerbille1144613gerbille
giggle94313513gi_ggle
gigolo836533gigo_lo
gigolos934693gigolos
gill56336183gi__ll_
gilled84521633gi__lled
giller74519733gi__ller
gillie74816943gi_llie
gills64728193gi__lls
gilly94321633gi__lly
giraffe1442993giraffe
girasole984423girasole
girdled10217453girdled
girdler9227313girdler
girdles92210003girdles
girl56226553gir__l_
girlier8289523gir_lier
girlies83013703gir_lies
girls64518393gir__ls
girly94415293gir__ly
giro55828633giro___
giron66118993giro__n
girons75014373giro_ns
giros65722653giro__s
girosol885303girosol
girosols984653girosols
golly95121103g__olly
gorilla836973gorilla
gribble12297273gribble
griddle1035503griddle
grill64617893g_rill_
grilled94012833g_rilled
griller84513353g_riller
grilles83715023g_rilles
grills74314803g_rills
grilse7399503g_rilse
gripple12416613gripple
gristle8169223gristle
grizzle16306113grizzle
groove10438873g_roove
grope84821613g_ro_pe
grosze16457733g_rosze
grouse74315023g_rouse
grove95219333g_ro_ve
grovel104310543g_rovel
growl96115823g_rowl_
growled12278173g_rowled
growler11318973g_rowler
growls104711113g_rowls
growly13499173g_rowly
groyne1037213g_royne
gurgle83912473gur_gle
gyrally1435583gyrally
gyrose105310253gyro_se
hirable121612313hirable
hirple11158973hir_ple
hirsle9159573hir_sle
ignoble1043613ignoble
irone55126363_iro_ne
kirtle10309473kir_tle
micelle1178343micelle
mille75029133mi__lle
miracle1138843miracle
morelle91210803morelle
oriole6814293orio_le
parole84425253paro_le
parolee94119643parolee
pinocle1138143pinocle
pinole83218783pino_le
pirogue1045413pirogue
piroque1844353piroque
prole74527793_pro_le
reroll6412683reroll_
rerolled93010053rerolled
reroller8258753reroller
rerolls739943rerolls
rille55728733__rille
roble75223023__roble
role45851823__ro_le
roll46331653__roll_
rolled74220243__rolled
roller63919793__roller
rolls55326233__rolls
scroll8310173scroll_
scrolled1137053scrolled
scrolls938063scrolls
stroll6311603stroll_
strolled937823strolled
stroller848183stroller
strolls739183strolls
troll54416533_troll_
trolled84312263_trolled
troller73913173_troller
trolley10328753_trolley
trolls64613943_trolls
trolly94012363_trolly
unroll61210073unroll_
unrolled9610413unrolled
unrolls797793unrolls
virally1339653virally
virgule1144283virgule
virile9313433vir_ile
wirable121610963wirable
zorille1636673zorille

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 Limit1340271396.76619808.9
3Display Results1391390.0463021.7
 (SQL Overall)1786911397.21824756.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.