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

119 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
subzero183561(None) 
suber74924502sub_er_
subers85722642sub_ers
subsere9311442subsere
subvert12312892subvert
buzzer16379113buzzer_
buzzers17347173buzzers
cuber95222533cub_er_
cubers105318353cub_ers
dubber113814553dubber_
dubbers124011823dubbers
lubber104214623lubber_
lubbers113913723lubbers
nonzero1646123nonzero
rezero1578873_rezero
rubber104715793rubber_
rubbers113913193rubbers
rubbery14337593rubbery
rubier84814743rubier_
saber75330243sab_er_
sabers85224733sab_ers
santero7311133santero
seizer154114573seizer_
seizers164112503seizers
sizer145521813s_izer_
sizers155215813s_izers
slubber113010763slubber_
slubbers12349943slubbers
snubber11277733snubber_
snubbers12326673snubbers
sobber104016593sobber_
sobbers114114263sobbers
sober74822413sob_er_
sobers85218863sob_ers
sombrero1242583sombrero
suaver93014233suaver_
subarea939403subarea
subbed114116673subbe_d
subcell1146753subcell
subclerk1643793subclerk
subdean1037403subdean
subdeb1137523subde_b
subdebs1236483subdebs
subdepot1344683subdepot
subduer10107033subduer_
subduers1186363subduers
subecho1445073subecho
suberic11312213sub_eric
suberin9314563sub_erin
suberose10109693sub_erose
suberous10311793sub_erous
subgenre1144873subgenre
subhead1387693subhead
subito8410453sub_ito
subject18258633subject
sublet82827243suble_t
sublets92616703sublets
submenu1148363submenu
submerge1345513submerge
submerse1237633submerse
subnet82520933subne_t
subnets92512083subnets
suborn8310013sub_orn
subpar1048663subpar_
subpart11311123subpart
subpena1136673subpena
subperiod1445643subperiod
subrent9315083subrent
subsea82610193subse_a
subsect112611843subsect
subseres10312423subseres
subserve1346463subserve
subset83122583subse_t
subsets92813103subsets
subteen938523subteen
subtend1037103subtend
subtest9513963subtest
subtext1647653subtext
subtler92910843subtler_
suburb1037163sub_urb
subvene1238493subvene
subverts1336973subverts
subzone1846993subzone
sucker124120663sucker_
suckers133717623suckers
sudser73511283sudser_
sudsers83310423sudsers
suer45334033su__er_
suers55128483su__ers
suffer124314513suffer_
suffers133113543suffers
suiter64121813suiter_
suiters73618883suiters
sulker104015923sulker_
sulkers113613343sulkers
summer104017713summer_
summers113616503summers
summery14329413summery
sunder74019823sunder_
sunders84120053sunders
super74924483su_per_
superb104410993su_perb
supers84622403su_pers
supper104115433supper_
suppers113314703suppers
supremo1145723supremo
surer54833093su_rer_
surfer93515883surfer_
surfers103614133surfers
surger74320093surger_
surgers83517483surgers
surgery11319213surgery
sutler63718393sutler_
sutlers73116973sutlers
tubber104313203tubber_
tubbers113411253tubbers
tuber75420683tub_er_
tubers85017033tub_ers
zero134822473___zero

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271198.26616214.3
3Display Results1191190.0462587.0
 (SQL Overall)1786911198.46821101.9
 
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.