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

114 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
tzarinas173397(None) 
czarinas1935291czarinas
tsarinas835271tsarinas
tzarina1635051tzarina_
carinas93622402_carinas
czarina1845952czarina_
farinas103215232_farinas
jarinas143712182_jarinas
marinas93519382_marinas
ocarinas1036722ocarinas
tsarina736652tsarina_
tzarevnas215952tzarevnas
tzarisms1965212tzarisms
tzarists1755692tzarists
tzaritzas1791252tzaritzas
zaribas1836042_zaribas
acarines10314343acarines
arenas65021993__arenas
arias55438023__ari_as
bearings113912253bearings
carina84325323_carina_
carinae94318583_carinae
carinal94318233_carinal
caritas93316953_caritas
czardas1934673czar_das
czarevnas2341353czarevnas
czarisms2155753czarisms
czarists1966223czarists
czaritzas1991643czaritzas
darings93713653_darings
dharnas1155373dhar_nas
earings84517713_earings
farina94618233_farina_
farinhas14325363_farinhas
gearings10359503gearings
guaranas995943guaranas
harianas1139163_harianas
hearings123611853hearings
jarina134014063_jarina_
laminas93615873_laminas
latinas74416463_latinas
marina84623413_marina_
marines93928013_marines
ocarina948033ocarina_
parians93519733_parians
parings104219213_parings
patinas96318523_patinas
platinas103610313platinas
roarings9248293roarings
salinas73116093_salinas
sarcinas1039273_sarcinas
sarins63932623_sarin_s
sharias102516003shari_as
soarings93210393soarings
spartinas1135793spartinas
staminas1048853staminas
stearines9311283stearines
stearins8312143stearin_s
tacrines10310563tacrines
taenias7311283t_aenias
tafias93111963t_afi_as
tahinis1048013t_ahinis
taigas73712563t_a_igas
tains54936323t_a_in_s
taints64520533t_a_ints
takings124512573t_akings
takins105117403t_akin_s
tamarinds1244163tamarinds
tamarins10310843tamarin_s
taramas9612703t_aramas
tarantas839193t_arantas
tariffs1334593t_ariffs
taring73932283t_arin_g
tarnal63716503t_ar_nal
tarns56433953t_ar_n_s
tarpans92513533t_arpans
tarsias74013373t_arsias
tartanas8258893t_artanas
tartans72615823t_artans
tarzans16329923t_arzans
taurines8310553taurines
teargas837013tear_gas
teariness9310633teariness
tearing84021493tearin_g
terrines82117553terrines
therians1138313therians
thorias102312053thori_as
tiaras6314553tiar__as
tourings9277373tourings
tracings112910413tracings
trains64725343tra_in_s
trinal6516963t__rinal
trines64132563t__rines
tronas63816903t__ronas
tsarevnas1241073tsarevnas
tsarisms1056653tsarisms
tsarists857303tsarists
tsaritzas1881393tsaritzas
twains95811183twa_in_s
tzardoms2043273tzardoms
tzarevna204973tzarevna_
tzarism1866323tzari_sm
tzarist1659103tzari_st
tzaritza1681673tzaritza
tzars144914273tzar___s
tzuris15286913tzuri__s
vaginas11298813_vaginas
varias95019903_vari_as
varnas94212823_var_nas
zamias174212923_zami_as
zananas16319563_zananas
zarebas1836303_zarebas
zariba1736983_zariba_
zayins18409713_zayin_s

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621147.45019619.1
3Display Results1141140.0502280.0
 (SQL Overall)1786911147.65623340.0
 
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.