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

76 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
piscinas127548(None) 
piscina1177041piscina_
piscinae1285211piscinae
piscinal1285841piscinal
episcias1244882episci_as
pastinas103712152pastinas
piecings1345332piecings
piscine11610972piscin_e
cassinas103610633cassinas
discants112912023discants
discing113914593discin_g
encinas938723_encinas
episcia1145123episci_a_
exscinds1842533exscinds
fascias1258413fasci_as
fascines13310143fascines
ficins113513983fi_cin_s
fishings15307693fishings
hissings12556753hissings
icings9428453_i_cings
katcinas1434513katcinas
listings93310043listings
misbias1139083misbi_as
misbinds1345163misbinds
miscites12313783miscites
miscoins12311083miscoin_s
niacins938543niacin_s
oscines9310363_oscines
paisanas10288873pais_anas
pashminas1642903pashminas
passings11409873passings
pastina93914593pastina_
patinas96318523p_atinas
pembinas1454133pembinas
picaras11311273pi_caras
picas94626523pi_c__as
pickings17359383pickings
picnics13297343pi_cnics
pidgins11259123pidgin_s
piecing12410453piecin_g
piercings1453253piercings
piggins113010473piggin_s
pigskins1544253pigskin_s
pilings103313613pi_lings
pinas75434453p___inas
pinkings15338143pinkings
pinnas85315513pi__nnas
pipings12338253pi_pings
pipkins15328183pipkin_s
pippins10319753pippin_s
piranas9912603pi_ranas
piscos105112593pisc__os
pishing134314373pishin_g
pismires1235883pismires
pissants1097363pissants
pissing103914803pissin_g
pistils93314303pisti_ls
pistons93016373piston_s
pittings11349123pittings
platinas103610313platinas
poincianas1462243poincianas
porcinis1246953porcinis
postings112912303postings
postins93721203postin_s
prescinds1444953prescinds
rescinds1136333rescinds
ricins83618703ri_cin_s
ricinus9408123ri_cinus
risings83211893ris_ings
sarcinas1039273sarcinas
scenas84114703__scenas
sestinas8249133sestinas
siskins1159583siskin_s
vaccinas1544973vaccinas
vicinal12268543vi_cinal
vicunas1285613vi_cunas

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.186960704.3
2DLD Change Limit146162768.08018089.4
3Display Results76760.0302533.3
 (SQL Overall)178691768.29621539.4
 
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.