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 “prebilling” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
prebilling159541(None) 
rebilling12228831_rebilling
perilling12410002p_erilling
prebidding1783842prebidding
prebinding1696162prebinding
preboiling1546402preboiling
prebuilding1742382prebuilding
prechilling1943742prechilling
predrilling1543672predrilling
prefiling1549532prefi_ling
preselling1338692preselling
pretelling1338132pretelling
prilling113413412pr__illing
rebelling122111162_rebelling
refilling13299332_refilling
billing103823853___billing
brailling1247773br_ailling
crenelling1345683crenelling
devilling1436703_devilling
drilling103311983dr__illing
eyeballing1642263eyeballing
fireballing1742643fireballing
frilling123011493fr__illing
grilling103811533gr__illing
misbilling1545543misbilling
overbilling1766023overbilling
pebbling1535073p_eb_bling
pedalling1346663p_edalling
pencilling1545473pencilling
periling11316863p_eri_ling
pilling103722563p___illing
pinballing1544013pinballing
prebaking1838063preb_aking
prebill1138803prebill___
prebilled1445063prebill_ed
prebills1237293prebill__s
prebooking1944073prebooking
prebuying1734303preb_uying
precising14413273preci_sing
precooling1545963precooling
predicting1649873predicting
prefiring1559073prefi_ring
prefixing2246783prefi_xing
prehiring1548383prehi_ring
premiering1547243premiering
premising14412413premi_sing
premixing2157803premi_xing
premolding1644673premolding
prerinsing1347643prerinsing
presiding13510903presi_ding
presifting1638083presifting
preslicing1546363preslicing
presolving1644363presolving
prevailing1656723prevailing
prevaluing1644273prevaluing
previewing1943673previewing
prevising15510873previ_sing
prewiring1547893prewi_ring
profiling1548233profi_ling
propelling1556933propelling
rebidding14275463_rebidding
rebinding13249483_rebinding
reboiling12149823_reboiling
rebuilding1443633_rebuilding
recalling122211903_recalling
redialing11311843_redialing
redialling1246203_redialling
redrilling1246073_redrilling
refalling132010423_refalling
refelling132211313_refelling
refiling123116533_refi_ling
refilming15256463_refilming
regilding1236123_regilding
reoiling93217213_reoi_ling
repelling122312753_repelling
repolling122110203_repolling
rerolling102210373_rerolling
reselling102213833_reselling
resiling93520173_resi_ling
retelling102112493_retelling
retiling93319483_reti_ling
retitling1039773_retitling
revelling132412553_revelling
reviling122917213_revi_ling
rilling84023623_r__illing
trebling1139873treb__ling
trilling92815963tr__illing

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 Filter1786911406030.420425454.8
2DLD Change Limit140603876.42321890.5
3Display Results87870.0332636.4
 (SQL Overall)178691876.87625987.6
 
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.