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

71 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
budgeter124454(None) 
budgeted1344881budgeted
budgeteer1342771budgeteer
budgeters1343591budgeters
budger104617702budg__er
budget104618112budget__
budgetary1651802budgetary
budgeteers1451992budgeteers
budgets11489862budget_s
buffeter1683592buffeter
cudgeler1253312cudgeler
fidgeter1343782fidgeter
badger105415073badg__er
badgered1336213badgered
bedwetter1542663bedwetter
begetter11136313b_egetter
billeter1037563billeter
biometer1239603biometer
blighter1466853blighter
bludger11419563bludg__er
brighter1476663brighter
bucketed1736763bucketed
budder104314813bud__der
budge94619873budg__e_
budged114517233budg__ed
budgers114314923budge_rs
budges104820123budg__es
budgeting1444023budgeting
budgie104310343budg_ie_
budgies115312513budg_ies
buffeted1753733buffeted
buffeters1783143buffeters
bugeye1236533bu_geye_
bugeyes1335513bu_geyes
bugger104418723bu_g_ger
buggered1335623buggered
buggier113611343bu_ggier
bugler94717723bu_g_ler
bulger94917353bulg__er
bulgier103911213bulg_ier
bulleted1138393bulleted
bungee96319773bunge_e_
bungees104513103bunge_es
bungler104611483bung_ler
bunter85020383bu__nter
burdener1136133burdener
burgee97120593burge_e_
burgees104915893burge_es
burger94020793burg__er
burgher1337003burg_her
burster9310293bu_rster
busheler1374753busheler
buster84726493bu__ster
butter84724233bu__tter
cudgeled1343123cudgeled
cudgelers1343083cudgelers
deter65028043__d_eter
dieter73516773__dieter
fidgeted1443893fidgeted
fidgeters1443613fidgeters
gadgeteer1242413gadgeteer
judger154411443judg__er
junketer1943713junketer
nudger85111633nudg__er
pudgier11377723pudg_ier
quieter162810333qu_ieter
ruggeder1142723ruggeder
suggester1143733suggester
udometer1146333_udometer
unbudgeted1551863unbudgeted
ureter6313203_u_reter

Search took 9 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 Limit146162717.87618557.9
3Display Results71710.0302366.7
 (SQL Overall)178691718.06222164.6
 
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.