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

129 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
girolles93552(None) 
girolle835791girolle_
girdles92210002gir_dles
girlies83013702gir_lies
grilles83715022g_rilles
airholes1138033airholes
binocles1236413binocles
birles84920643bir__les
brollies1039533_brollies
carolled1138833carolled
caroller1039203caroller
carollers1137703carollers
ciboules1244533ciboules
circles1139903cir_cles
citoles9312553cito_les
corollas1039213corollas
criollos1043713criollos
dipoles101013753dipo_les
drolled93810223_drolled
droller84110283_droller
drollest937353_drollest
drolls75312393_droll_s
enrolled967973enrolled
enrollee878343enrollee
enrollees974323enrollees
enroller867183enroller
enrollers976173enrollers
enrolls7108093enroll_s
filles94224523fi__lles
folles93820473__folles
gabelles11278933gabelles
garbles104016923gar_bles
gargles94214893gar_gles
gargoyles1442833gargoyles
garotes8614573garo_tes
garottes978293garottes
gazelles18266563gazelles
gerbilles1244013gerbilles
giggles103312933gi_ggles
gigolos934693gigo_los
gilled84521633gi__lled
giller74519733gi__ller
gillers84216903gi__llers
gillies84120963gi_llies
gills64728193gi__ll_s
giraffes1542603giraffes
girasoles1083713girasoles
girdle82110463gir_dle_
girdled10217453gir_dled
girdler9227313gir_dler
girdlers10195403girdlers
girlie73711463gir_lie_
girlier8289523gir_lier
girliest93010403gir_liest
girls64518393gir__l_s
girons75014373giro__ns
giros65722653giro___s
girosols984653girosols
girshes11248293gir_shes
gorillas946373gorillas
gribbles13307363gribbles
griddles1145753griddles
grille74315743g_rille_
grilled94012833g_rilled
griller84513353g_riller
grillers93810813g_rillers
grills74314803g_rill_s
grilses8319153g_rilses
gristles9189203gristles
grizzles17286193grizzles
grooves11368803g_rooves
gropes95220403g_ro_pes
grosses84517683g_rosses
grouses84616543g_rouses
grovels11427813g_rovels
groves104318103g_ro_ves
growled12278173g_rowled
growler11318973g_rowler
growlers12327093g_rowlers
growls104711113g_rowl_s
groynes1137823g_roynes
gurgles94312873gur_gles
hirples12149643hir_ples
hirsles101510073hir_sles
irones64724013_iro_nes
ironies7517423_ironies
kirtles11309663kir_tles
micelles1288833micelles
milles84526563mi__lles
miracles1238333miracles
morelles10710493morelles
orioles7412993orio_les
parolees104313993parolees
paroles95025893paro_les
pinocles1248693pinocles
pinoles93418713pino_les
pirogies1139423pirogies
pirogues1135473pirogues
piroques1944353piroques
proles84627203_pro_les
rerolled93010063rerolled
reroller8258753reroller
rerollers9207123rerollers
rerolls739943reroll_s
rilles64725503__rilles
robles85321693__robles
roles56747983__ro_les
rolled74220243__rolled
roller63919793__roller
rollers73117473__rollers
rolls55326233__roll_s
scrolled1137063scrolled
scrolls938063scroll_s
strolled937823strolled
stroller848183stroller
strollers937563strollers
strolls739183stroll_s
trolled84312263_trolled
troller73913173_troller
trollers83211213_trollers
trolley10328753_trolley
trolleys11315693_trolleys
trollies8310233_trollies
trolls64613943_troll_s
unrolled9610413unrolled
unrolls797793unroll_s
virgules1244333virgules
viroses10310533viro_ses
zorilles1736123zorilles

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621297.39019778.3
3Display Results1291290.0502580.0
 (SQL Overall)1786911297.84622774.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.