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

98 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
blitzed19336531blitzed
blitzer18447661blitzer
blitzes18408701blitzes
blintze1833902blintz_e
blintzes1944262blintzes
blite76225352blit__e
blites84721212blit_es
blithe115810862blit_he
blither124812172blither
blitz165318132blitz__
blitzers19417152blitzers
glitzed18375492glitzed
glitzes17367562glitzes
alienee71013153alienee
bailee84526013bai_lee
baited95319243bait_ed
baiter84422563bait_er
baize164717393bai_z_e
baizes174315053bai_zes
belittle1044053belittle
bite66547013b_it__e
biter75030033b_it_er
bites75641173b_it_es
bitted94418483b_itted
bitten84715123b_itten
bitter84622673b_itter
bize155926303b_i_z_e
bizes165923663b_i_zes
bizzes163910843b_izzes
blate75933783blat__e
blather125314213blather
blatted104812713blatted
blatter94415653blatter
blaze165520833bl_az_e
blazed184314713bl_azed
blazer174414023bl_azer
blazes174817353bl_azes
blether12459913blether
blimey13468453bli_mey
blinded114810023blinded
blinder103912993blinder
blinked144010013blinked
blinker134110213blinker
blintz1788843blintz__
blipped14377193blipped
blissed10388373blissed
blisses94911513blisses
blister94415313blister
blithely16104033blithely
blithered15156123blithered
blithers134711233blithers
blithest1338083blithest
blitzing2035903blitzing
blotted103911833blotted
blotter94612853blotter
blowzed22435973blowzed
boite74426323boit__e
boites84322703boit_es
bootee84323023boot_ee
bortzes1838223bortzes
bribee104316363bri_bee
brittle9168603brittle
britzka22132133britzka
ditzes163212423_ditzes
elite56230183elit__e
elites66027123elit_es
flite85424963flit__e
flited104616583flit_ed
flites95122443flit_es
flitted114011643flitted
flitter103413903flitter
fritzes19329453fritzes
glitter84211803glitter
glitz154916373glitz__
glitzier1833593glitzier
glitzy19404783glitz_y
klutzes2064113klutzes
lichee114017973_lichee
listee64223063_listee
lite47054553_lit__e
liter54736343_lit_er
lithe84922013_lit_he
lither94520953_lither
litre55421463_lit_re
litres65220393_litres
litten64014873_litten
litter64324853_litter
little63312163_little
lutzes153711923_lutzes
obligee1046863obli_gee
plotzed19376223plotzed
plotzes18317703plotzes
prithee1239933prithee
ritzes154812943_ritzes
slither104112983slither
slitted83513313slitted
slitter73615873slitter
spitzes1849183spitzes

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.466383457.1
2DLD Change Limit134027987.05019010.9
3Display Results98980.0303266.7
 (SQL Overall)178691987.54623680.2
 
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.