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

248 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
pregame123955(None) 
pregames1339001pregames
prename11412641prename
degame102713182_degame
preamp1238992pre_amp
prebade12310282prebade
prebake1539092prebake
predate10616892predate
preface14510922preface
prefade1339012prefade
preflame1545912preflame
prelate9519692prelate
premade12311442premade
prenames12311642prenames
prepare111913622prepare
prepave14228872prepave
prerace11414122prerace
presage10312292presage
presale9416352presale
presume11310302presume
pretape113511622pretape
regale74821452_regale
regave104713382_regave
regime95313942_regime
rename82718812_rename
arame75026623ar__ame
areae55229743are_a_e
became123213163_became
begaze1838333_begaze
bename103316073_bename
bream95121813bre_am_
breamed124011593bre_amed
breams104815043bre_ams
bregma1134963breg_ma
bregmate1345533bregmate
brewage1347183brewage
brigade1136493brigade
cream95721353cre_am_
creamed123913713cre_amed
creamer113714093cre_amer
creams104715253cre_ams
creamy134811363cre_amy
crease85519573cre_ase
create85126383cre_ate
cremate113816183cremate
creme94319323cre__me
crenate93317113crenate
defame123212433_defame
degage92711383_degage
degames113312623_degames
degami10279013_degami
dream85120393dre_am_
dreamed114310633dre_amed
dreamer104110843dre_amer
dreams94513983dre_ams
dreamt94615713dre_amt
dreamy12509993dre_amy
endgame1145233endgame
ergate7315143er_gate
forename1347853forename
frame105821803fr__ame
frigate11311063frigate
game76644323___game
grease75416233gre_ase
greave104611493gre_ave
grenade938413grenade
legate72917453_legate
legume936913_legume
negate72915573_negate
nongame1038183nongame
oregano846253oregano
origami1045453origami
peace95026083p_e_ace
peage84723573p_e_age
pease75231113p_e_ase
pedate93117763p_edate
peerage1089803peerage
pelage9515363p_elage
penname11328553penname
percale11314093percale
perfume1446503perfume
pervade1337023pervade
pesade9311103p_esade
phenate12412193phenate
please84315733ple_ase
postgame1345523postgame
praam94815613pr_aam_
praams10459643pr_aams
pram85733493pr__am_
prams96125513pr__ams
prase76128753pr__ase
prate75135983pr__ate
preach133613923pre_ach
preact103220393pre_act
preaged11612333preaged
preamble1436383pre_amble
preamps1336613pre_amps
prearm104512353pre_arm
prearmed1397993prearmed
prearms11369173prearms
preaver121011613pre_aver
prebaked1737173prebaked
prebakes1639013prebakes
precast11314853precast
precava1445093precava
precavae1544813precavae
precede1239653precede
precipe133012123precipe
precise113518173precise
precode12311853precode
precure11312553precure
predated12513273predated
predates11615813predates
predawn1335353predawn
predive13511083predive
pree67044733pre___e
preemie11310563preemie
prefab1336243prefa_b
prefabs1435163prefabs
prefaced1638423prefaced
prefacer1537983prefacer
prefaces15311063prefaces
prefaded1537823prefaded
prefades1439533prefades
prefile123413183prefile
prefire124012813prefire
pregnable1456693pregnable
pregnant1149883pregnant
preguide1255423preguide
prelacy1437583prelacy
prelates10418573prelates
prelaw1139103prela_w
prelife1279943prelife
prelim10311423prelim_
prelims1139823prelims
prelude1038013prelude
preman104117453prema_n
premed114617763pre__med
premen105017803pre__men
premie103617993pre_mie
premise113818553premise
premune1138933premune
prenomen1249633prenomen
prepack1757643prepack
prepaid12310133prepaid
prepared132210873prepared
preparer12169643preparer
prepares122014163prepares
prepaste12139083prepaste
prepaved16177233prepaved
prepaves15189193prepaves
prepay13310313prepa_y
prepays1437483prepays
preplace1488983preplace
preppie1058093preppie
prepuce1337833prepuce
presa74319043presa__
presaged1238803presaged
presager1138443presager
presages11312203presages
presales10315263presales
prese75228383pre__se
preshape1537533preshape
preside10715613preside
pressmen1238833pressmen
prestamp1445323prestamp
presumed1337973presumed
presumer1247583presumer
presumes1239843presumes
pretaped13339133pretaped
pretapes122811533pretapes
pretaste10139523pretaste
pretax152310193preta_x
pretype14387483pretype
prevail1238243prevail
prevalue1345073prevalue
previse123713793previse
prevue1179163pre_vue
prewar114712583prewa_r
prewarm14479613prewarm
prewarmed17104563prewarmed
prewarms15406733prewarms
prewarn124410153prewarn
prewash1535213prewash
prewire124311143prewire
primage12169143primage
primate111516283primate
prime96525603pr__ime
private121513263private
probate11414483probate
profane122111863profane
prograde1247183prograde
program12311693program_
programed1585893programed
programer1475603programer
programme1694783programme
programs1339783programs
prolate9419793prolate
pronate9418873pronate
propane112716153propane
prorate9418733prorate
ream65841613_re_am_
reamed94326123_re_amed
reamer84325213_re_amer
reams75729623_re_ams
reave84528023_re_ave
rebate84424113_rebate
recane83022873_recane
reclame11411063_reclame
redate74124683_redate
reface113616353_reface
reframe1239393_reframe
regain74517763_regain
regal65023793_rega_l
regaled93615963_regaled
regaler83814623_regaler
regales83520793_regales
regard85215773_regard
regauge945813_regauge
reggae858953_reggae
regimen104411573_regimen
regimes104514743_regimes
regive104814323_regive
reglaze1747223_reglaze
reglue739703_reglue
regma84612333_reg_ma
regrade92612033_regrade
regrate82618663_regrate
relace83122153_relace
relate64033633_relate
relume8313273_relume
remade94316983_remade
remake124016113_remake
remate84428683_remate
renamed103114523_renamed
renames92418053_renames
repave114813873_repave
resale64025543_resale
resume8313783_resume
retake104718533_retake
retape83917683_retape
retime85321803_retime
revamp1336013_revamp
rewake135218463_rewake
rugae65114763_ruga_e
rugate75813813_rugate
sesame8311013_sesame
urease64516993ure_ase

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.440406115.9
2DLD Change Limit1340272487.01619103.1
3Display Results2482480.0932666.7
 (SQL Overall)1786912487.54923670.8
 
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.