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

83 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
aucuba104549(None) 
aucubas1145171aucubas
ausubo853652ausubo
scuba94211592_scuba
succuba1343442succuba
aba512850953a___ba
abba810522643a__bba
accusal11136003accusal
accuse103411033accuse
aceta74017353a_ceta
acicula11228133acicula
acta69524803a_c_ta
acute74720363a_cute
aecia73819283aec_ia
ajuga1335883a_juga
alba68328333a__lba
alula5317093a_lula
ameba9312373a_meba
amoeba1035593amoeba
anchusa1244333anchusa
aqua132813963a_qu_a
arcana8912583arcana
arcus76918863arcu_s
arriba867673arriba
arroba898663arroba
arugula843913arugula
ascus75013583ascu_s
auburn836213auburn
augur64311213augu_r
augural856403augural
augurs7399963augurs
augury10366663augury
august739203august
aura45836253a__ura
auricula1045803auricula
aurora6411763aurora
aurum7614963auru_m
aurums849383aurums
ausubos942943ausubos
autumn836013autumn
bacula103112673bacula
bubba84311793bu_bba
buckra1436753buckra
caucus1039603caucu_s
cub76940943__cub_
cube85830213__cube
cubs85832383__cubs
cupula10328433cupula
curcuma1344773curcuma
facula112912233facula
fecula113310053fecula
fucus105515893fucu_s
furcula1245793furcula
fusuma1134503fusuma
incubi1035103incubi
juba134916983__juba
jugula1434983jugula
jujube1442413jujube
lacuna8118123lacuna
lunula636173lunula
macula103013673macula
macumba1573043macumba
mucosa10166273mucosa
mucus94015743mucu_s
nucha10229793nuc_ha
oscula837293oscula
pucka133412803puc_ka
rumba93612513ru_mba
saxtuba1641693saxtuba
scubas103710223_scubas
scuta75815753_scuta
suba64926603__suba
succubae1443083succubae
succubas1443853succubas
succubi1342883succubi
tsuba745563_tsuba
tuba65422363__tuba
uvula845153_uvula
vacua10510463vacu_a
vascula1245853vascula
vicuna11115903vicuna
yuca95716723yuc__a
yucca12467443yuc_ca

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 Filter1786911127160.186960704.3
2DLD Change Limit112716836.61017052.3
3Display Results83830.0302766.7
 (SQL Overall)178691836.82626178.0
 
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.