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

173 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
prebill113880(None) 
prebills1237291prebills
prepill1147581prepill
rebill84713251_rebill
prebid113512842prebi_d
prebids12399882prebids
prebilled1445062prebilled
prebind123810642prebind
preboil1148952preboil
preboils1267292preboils
prebuild1344302prebuild
prebuilt1247032prebuilt
prechill1546192prechill
predial103815412predial
predrill1145932predrill
prefile123413182prefile
presell939292presell
pretell938232pretell
prill74117942pr__ill
rebills93510622_rebills
refill94514052_refill
bill67239943___bill
bluebill1243593bluebill
brill74819953br__ill
dreidl835233dre_idl
drill64718263dr__ill
eyeball1245063eyeball
fireball13127263fireball
freewill1443413freewill
frill84917563fr__ill
gerbil938343gerbi_l
gerbille1144613gerbille
gerbils1037303gerbils
gremial1039153gremial
grill64617893gr__ill
harebell1344353harebell
hornbill1384173hornbill
krill94213643kr__ill
misbill1137033misbill
overbill1337283overbill
pebble1238003p_ebble
pebbly1545083p_ebbly
penial84120893p_enial
penile82219603p_enile
peril75425953p_eri_l
perilla9311223p_erilla
perils84121853p_erils
perkily1637803perkily
piebald1245503piebald
pill65339463p___ill
pinball1137933pinball
playbill1543373playbill
praedial1178763praedial
preanal9310713preanal
preaxial1746973preaxial
prebade12310283prebade
prebake1539093prebake
prebasal1244723prebasal
prebend12319443prebend
prebilling1595413prebilling
prebinds13357733prebinds
prebirth1543463prebirth
preboiled1455783preboiled
prebook1557523prebook
preboom1348243preboom
prebuilds1442633prebuilds
prebuy1357423preb_uy
prebuys1444393prebuys
prechills1645123prechills
precipe133012123precipe
precis103416703preci_s
precise113518173precise
precool1139013precool
predella1145383predella
predict12315323predict
predive13511083predive
predrills1244473predrills
preeing103817673preeing
prefiled143310573prefiled
prefiles133113443prefiles
prefilled1535513prefilled
prefire124012813prefire
prefix18356853prefi_x
prefixal2044543prefixal
prelife1279943prelife
prelim10311423preli_m
prelims1139823prelims
premeal11310513premeal
premie103617993premi_e
premier113515633premier
premies113823063premies
premise113818553premise
premiss113513813premiss
premium13310363premium
premix173710333premi_x
premixt183510663premixt
premold1247863premold
premolt11312073premolt
preoral9312673preoral
preppily1444583preppily
prequel1836343prequel
preriot9316413preriot
presale9416353presale
presells1058273presells
preside10715613preside
presift12312223presift
presold1059603presold
pretells1047323pretells
pretold1049083pretold
pretrial10511983pretrial
prettily1337273prettily
pretzel1835143pretzel
prevail1238243prevail
prevails1337663prevails
preview1536473preview
previse123713793previse
prewire124311133prewire
prexies163415003prexies
preying133114553preying
pricily142710283pricily
prills84015613pr__ills
privily15207623privily
probing123314443probing
probit103218353probi_t
probits112712573probits
probity14299683probity
proemial1249183proemial
profile123211153profile
prosily12611633prosily
pueblo1035553pueb_lo
puerile9310093puerile
pyrexial20234963pyrexial
rebel73421293_reb_el
rebels84518133_rebels
rebid85121363_rebi_d
rebids94015533_rebids
rebilled11318053_rebilled
rebind94416933_rebind
reboil83814683_reboil
reboils94111723_reboils
rebuild1036293_rebuild
rebuilt939973_rebuilt
recall83815723_recall
redial74923113_redial
redrill857893_redrill
refall94314393_refall
refell94214443_refell
refile95122373_refile
refills103711423_refills
refilm114311403_refilm
regild8149773_regild
regilt71217493_regilt
reoil55321183_reoi_l
reoils64516873_reoils
repoll8410793_repoll
reroll6412683_reroll
resell64215203_resell
resile64627673_resile
retell63813643_retell
retial64724993_retial
retile65929673_retile
revile94921613_revile
rill45140903_r__ill
sawbill1255293sawbill
shoebill1344213shoebill
treble8311663treb_le
trebly1138973treb_ly
trill55122933tr__ill
twibill1242743twibill
uredial82910483uredial
verbile1249863verbile
waxbill1943133waxbill
waybill1543723waybill

Search took 7 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.1561145455.1
2DLD Change Limit1340271736.51620568.9
3Display Results1731730.0632746.0
 (SQL Overall)1786911736.73526531.7
 
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.