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

142 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
billeting123664(None) 
bulleting1236641bulleting
filleting1335851filleting
balloting1238392balloting
billing103823852bill__ing
billowing1545872billowing
bulletin1046772bulletin_
bulletins1146332bulletins
colleting12311072colleting
fileting1239302fi_leting
galleting1137632galleting
gimleting1343862gimleting
palleting1238742palleting
pelleting1237952pelleting
tillering1037882tillering
alleging1038473_alleging
ballasting1345303ballasting
ballerina1146493ballerina
balletic1248073balleti_c
balling104424763ball__ing
basseting1236153basseting
befleaing1544023befleaing
believing1535283believing
belling103825073bell__ing
bellowing1547193bellowing
bellying14359073bell_ying
belting104119133b_el_ting
bickering1837673bickering
bielding12237473biel_ding
bighting15269453bi_ghting
bilging114212683bi_l_ging
bilking144413553bi_l_king
billabong1441963billabong
billet86029723billet___
billeted1137643billet_ed
billeter1037563billet_er
billeters1136873billeters
billets94516153billet__s
billings113412633bill__ings
biltong1034683bi_l_tong
bingeing12237643binge_ing
birling104317053birl__ing
bisecting1436973bisecting
bitewing1435293bi_tewing
biting95321823bi___ting
bittering122512003bittering
bitting103717293bi__tting
blasting114013433b_lasting
blatting114111653b_latting
bleating113514503b_leating
bleeding12359053b_leeding
bleeping13377933b_leeping
blighting1635733blighting
bloating113512813b_loating
blotting113910433b_lotting
blueing103710203b_lue_ing
blunting11319843b_lunting
blurting11258773b_lurting
bolling103820883boll__ing
bollixing1944813bollixing
bolloxing1944773bolloxing
bolting104416763b_ol_ting
bonneting1236173bonneting
breveting1536273breveting
bucketing1835713bucketing
budgeting1444023budgeting
buffeting1843783buffeting
bulletined1343683bulletined
bulletining1452503bulletining
bulling104324793bull__ing
bullring11388423bull_ring
bullying14329293bull_ying
collating12312783collating
collecting1548283collecting
deleting103314423_deleting
depleting1378193depleting
dieting93616833di__eting
dilating102714913di_lating
diluting10248983di_luting
fellating1339253fellating
fidgeting1544523fidgeting
filiating1339253filiating
filling113520803fill__ing
filliping1544233filliping
filtering13199723filtering
fleeting122910323_fleeting
fullering1336653fullering
gibbeting1542903gibbeting
gilling93520383gill__ing
gillnetting1351543gillnetting
gillying13306813gill_ying
gleeting10279173_gleeting
helmeting1545503helmeting
hilling113821773hill__ing
hilloaing1375433hilloaing
hilloing12158303hill_oing
hilting113316893hi_l_ting
hollering1337743hollering
illuding1035803_illuding
illuming1135873_illuming
inletting1087873_inletting
jilting153211743ji_l_ting
killing123118723kill__ing
kilting123213853ki_l_ting
lilting83515383li_l_ting
mildening1345673mildening
mildewing1643733mildewing
milling103223683mill__ing
milting103619123mi_l_ting
nilling83619563nill__ing
obsoleting1342743obsoleting
picketing1835683picketing
pilfering1536393pilfering
pillaging1345573pillaging
pillaring1237653pillaring
pilling103722563pill__ing
pillowing1545493pillowing
piloting1139693pi_loting
pollening1236933pollening
polluting1235703polluting
rilling84023623rill__ing
riveting12139443ri_veting
signeting1136223signeting
silting83320483si_l_ting
silvering1337923silvering
sleeting93114163_sleeting
tableting1236353tableting
telneting1035593telneting
ticketing1635633ticketing
tilling83522783till__ing
tilting83417103ti_l_ting
toileting1036263toileting
valeting1238853_valeting
villein1036753ville_in_
villeins1136043ville_ins
violating1337443violating
volleying1643763volleying
wildering1456743wildering
willing113821613will__ing
willowing1645323willowing
willying15306713will_ying
wilting113515913wi_l_ting

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411427.15620771.5
3Display Results1421420.0632254.0
 (SQL Overall)1786911427.65523343.0
 
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.