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

125 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
ocarinas103671(None) 
carinas93622401_carinas
ocarina948021ocarina_
acarines10314342acarines
carina84325322_carina_
carinae94318582_carinae
carinal94318232_carinal
caritas93316952_caritas
czarinas1935292czarinas
farinas103215232_farinas
jarinas143712182_jarinas
marinas93519382_marinas
tsarinas835272tsarinas
tzarinas1733972tzarinas
acacias11510403acaci_as
acapnias1255683acapnias
acaridan1165233acaridan
acaridans1254033acaridans
acarids105312243acari_ds
acarine9316003acarin_e
arenas65021993__arenas
arias55438023__ari_as
bearings113912253bearings
cabanas112413033_cabanas
cabins104418923_cabin_s
cains75334303_ca_in_s
cairns85313303_cairn_s
camisas113411923_camisas
canines93724033_canines
cannas84518403_ca_nnas
cantinas102713773_cantinas
capias10318353_capi_as
carbines123617533_carbines
cardias10715113_cardias
cardinal1139563_cardinal
cardinals1247993_cardinals
cardings123812633_cardings
caribes113715643_caribes
carices114220953_carices
caries85147623_cari_es
carinate103320243_carinate
caring95137993_carin_g
cariocas1239663_cariocas
carious93320283_carious
carlines103521643_carlines
carlings114015853_carlings
carlins93921913_carlin_s
carmines123617863_carmines
carnal83919203_car_nal
carnies94123963_carnies
carns75937563_car_n_s
carpings133812383_carpings
carvings143810203_carvings
casings104013513_casings
casinos93512833_casinos
casitas93312043_casitas
cassinas103610633_cassinas
catenas9313113_catenas
cavings134712543_cavings
cerias83321983_ceri_as
chinas115119403_c_hinas
coamings13349293coamings
coatings113811843coatings
cocaines121314443coca_ines
cocains111313923coca_in_s
codeinas11338023codeinas
coquinas1944783coquinas
corbinas12229393corbinas
coronas93916913_coronas
corridas1177313corridas
cortinas102212443cortinas
corvinas13238013corvinas
czarina1845953czarina_
darings93713653_darings
dharnas1155373dhar_nas
doctrinal1243903doctrinal
doctrines1247153doctrines
earings84517713_earings
farina94618233_farina_
farinhas14325363_farinhas
gearings10359503gearings
guaranas995943guaranas
harianas1139163_harianas
hearings123611853hearings
jarina134014063_jarina_
kachinas1736343kachinas
laminas93615873_laminas
latinas74416463_latinas
marina84623413_marina_
marines93928013_marines
oaring74225303o_arin_g
ochring13156673ochrin_g
opalines10311423opalines
outrings92811053outrings
ovarial1037613ovari_al
ovarian1037643ovari_an
ovaries10312653ovari_es
ovaritis1145953ovaritis
oxazines2434073oxazines
parians93519733_parians
parings104219213_parings
patinas96318523_patinas
platinas103610313platinas
roarings9248293roarings
rosarians945793rosarians
sacrings11278923sacrings
salinas73116093_salinas
sarcinas1039273_sarcinas
sarins63932623_sarin_s
scariness11310183scariness
scaring103421973scarin_g
scarious10610203scarious
sharias102516003shari_as
soarings93210393soarings
sonatinas945683sonatinas
spartinas1135793spartinas
staminas1048853staminas
tacrines10310563tacrines
tsarina736653tsarina_
tzarina1635053tzarina_
vaccinas1544973vaccinas
vaginas11298813_vaginas
varias95019903_vari_as
varnas94212823_var_nas
zaribas1836043_zaribas

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621258.45317291.1
3Display Results1251250.0462717.4
 (SQL Overall)1786911258.65520646.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.