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

93 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
autobus99651(None) 
aurous64119262auro_us
autobuses1145612autobuses
autos56523322auto__s
acetous9410363aceto_us
actors81016763acto_rs
adobes94411533a_dobes
adobos9438453a_dobos
aerobes9311493aerobes
aftosas10147153aftosas
airbus848343a_irbus
altos55822953alto__s
antibug1045153antibug
anurous7311553anuro_us
aqueous1636053aqueo_us
arrobas969213arrobas
astomous1047213astomous
atolls65511353a_tolls
atoms76817563a_to_ms
atones65225773a_tones
attorns738443attorns
aucubas1145173aucubas
aureus65314883au_reus
aurochs1245983aurochs
auroras7311703auroras
ausubos942943ausubos
auteur6107943aut_eur
auteurs7137503auteurs
authors10311853authors
autisms94311553autisms
autists73814853autists
auto47432083auto___
autobahn1343533autobahn
autobahns1443053autobahns
autobusses1243023autobusses
autoed7712823auto_ed
autofocus1452833autofocus
autoing8314043autoing
autolyse1175413autolyse
automan9310883automan
automat9414873automat
automats10410443automats
automen939653automen
autonym1246633autonym
autonyms1345983autonyms
autopen947123autopen
autopens1046633autopens
autopsy1244373autopsy
autumns943763autumns
awmous1157713awmo_us
bubus95115453bu__bus
bulbous1138293bulbous
cautious103110233cautious
colobus11389373colobus
cutoffs1533603cutoffs
cutout8315923cuto_ut
cutouts938033cutouts
duteous838453duteous
fatuous1037783fatuo_us
fucous11399863fuco_us
futons93911513futo_ns
hautbois1343103hautbois
hautboys1642773hautboys
jacobus1843173jacobus
lupous849433lupo_us
luteous739273luteous
motorbus1244443motorbus
mucous104411653muco_us
mutons84314363muto_ns
nautilus844073nautilus
octopus1144813octopus
outbuy1146943out_buy
outbuys1246053out_buys
putoffs1543333putoffs
putons83515153puto_ns
putout8315113puto_ut
putouts937083putouts
raucous938303rauco_us
rubus76415063ru__bus
rufous948273rufo_us
rugous739653rugo_us
sautoirs834923sautoirs
setous64917373seto_us
stobs75718233_stob_s
tabus74820923__tabus
tautogs875413tauto_gs
tofus86415423__tofus
tolus55024483__tolus
tonus56324303__tonus
torus54329763__torus
tutors6912333tuto_rs
tutus55214813tut__us
uterus639203_uterus

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 Filter1786911340270.1401276364.3
2DLD Change Limit134027936.23621492.5
3Display Results93930.0303100.0
 (SQL Overall)178691936.40627894.3
 
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.