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

67 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
tuatara74551(None) 
tuataras844861tuataras
tuatera756371tuatera
satara6315532_satara
tantara72410822tantara
tatar56122062t_atar_
tatars64619792t_atars
tuateras836192tuateras
avatar937523avatar_
avatars1036443avatars
bustard10389723bustard
cuatro838433cuat_ro
curara83712203cu_rara
custard10389973custard
datary10310243_datary
datura738033_datura
guarana886303guarana
guitar7117443guitar_
guitars8116863guitars
haftara13136093haftara
labara83712893_labara
lustra6358893lust_ra
mustard10359533mustard
pataca10311193_pataca
quasar1536833quasar_
quasars1646903quasars
quatre153512353quat_re
samara8313853_samara
sataras7315063_sataras
subtaxa1644483subtaxa
sultana7257803sultana
sutra54217933su_t_ra
tabard9313333t_abard
talar56225383t_alar_
talaria7412513t_alaria
talars66021683t_alars
tamarao977593t_amarao
tamarau9107063t_amarau
tamari8313413t_amari
tantaras8269543tantaras
tantra63713353t_antra
tarama8412733t_arama
tartana73010193tartana
tartar63214753tartar_
tartare73012683tartare
tartars73313403tartars
tatami839193t_atami
tater54138613t_ater_
taters64932203t_aters
tautaug883023tautaug
tauter64318023tauter_
teacart91113193teacart
teaware1048143teaware
tetra53417953t_et_ra
thataway1742953thataway
tiara5315913t__iara
tostada894953tostada
tufter9319933tufter_
tufters10298353tufters
tundra736423tu_ndra
turbary1236383turbary
tussar6369543tussar_
tussars7359253tussars
tutor5712493tu_tor_
tutors6912333tu_tors
uakari1046863_uakari
ultra539363_ult_ra

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.406440125.6
2DLD Change Limit134027676.00022337.8
3Display Results67670.0135153.8
 (SQL Overall)178691676.41927837.8
 
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.