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

104 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
pirogues113547(None) 
pirogies1139421pirogies
pirogue1045411pirogue_
piroques1944351piroques
brogues10719822_brogues
drogues9398392_drogues
epilogues1243832epilogues
pierogies1245872pierogies
piraguas1144452piraguas
pirogen1038262pirog_en
piroque1844352piroque_
pishogues1543002pishogues
prorogues1244882prorogues
rogues74617672__rogues
apologues1245023apologues
argues74516413_ar_gues
baroques1934863baroques
brogue94211033_brogue_
cirques1836463cir_ques
dialogues1144813dialogues
dirges84915103dir_g_es
drogue8938333_drogue_
eclogues1144573eclogues
epilogue1143753epilogue_
epilogued1342293epilogued
garigues1034953garigues
gigues8128993gi__gues
girolles935523girolles
irones64724013_iro_nes
ironies7517423_ironies
mirages102213533mirag_es
morgues1038273mor_gues
parges94529543par_g_es
parodies11313693parodies
parolees104313973parolees
paroles95025883paro_les
paroquet1947283paroquet
paroquets2043643paroquets
parous84024163paro_u_s
perdues103511333per_dues
perigees1189493perigees
periques1937653periques
picotees1247113picotees
piggies113813483pi_ggies
pigouts1037593pigo_uts
pilous84717753pilo_u_s
pingoes105116513pi_ngoes
pinocles1248693pinocles
pinoles93418703pino_les
pinones94717063pino_nes
pious74621273pi_o_u_s
pipages1289423pipag_es
piques1739093pi__ques
piracies12312643piracies
piragua1044643piragu_a
pirates93020323pir_ates
pirog83913673pirog___
piroghi13303843pirog_hi
pirogi9299013pirog__i
pishoges1446953pishog_es
pishogue1442833pishogue_
plagues103311063p_lagues
pogies94123543p__ogies
porgies103017003por_gies
porous84419483poro_u_s
prevues1239263p_revues
priories10312453priories
probes104119453p_ro_bes
procures1239213p_rocures
produces1347903p_roduces
profuse1237153p_rofuse
progged12409793p_rogged
progger11319373p_rogger
proggers12258163p_roggers
progress1137023p_rogress
progs86624153p_rog__s
progun968783p_rogu_n
proles84627203p_ro_les
prologues1246903prologues
prorogue1145243prorogue_
prorogued1343383prorogued
proses84733473p_ro_ses
prosses94019513p_rosses
proteus92511593p_roteus
proves114322253p_ro_ves
proxies163014933p_roxies
purges94421763pur_g_es
pursues94111373pur_sues
pyrogen1337353pyrog_en
pyrogens1437293pyrogens
pyrones123113303pyro_nes
pyropes142210193pyro_pes
rogue66417533__rogue_
rogued84711473__rogued
roques154912563__roques
roues56039353__ro_ues
rouges76022383__rouges
scrouges1136683scrouges
togues76014243__togues
viragoes1245233viragoes
virgules1244333vir_gules
viroses10310533viro_ses
virtues10338023vir_tues
vogues104011923__vogues

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.1561145455.1
2DLD Change Limit1461621047.76618820.8
3Display Results1041040.0303466.7
 (SQL Overall)1786911047.95222471.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.