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

167 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
ptisans931736(None) 
paisans93614751paisans
ptisan8417971ptisan_
artisans888522artisans
paesans93312692paesans
paisan84417072paisan_
paisana94010222paisana
paisanas10288872paisanas
paisano9429512paisano
paisanos10337552paisanos
paisas84317492paisa_s
partisans1167482partisans
pians75126962p_i_ans
pitmans11188742pitmans
pitsaws1234992pitsaws
poisons9310352poisons
prisons9313222prisons
tisane6311572_tisane
tisanes7311852_tisanes
titans63414912_titans
artisan759463artisan_
atamans9710433atamans
atmans84413963at_mans
avians93711563avi_ans
bartisans1165553bartisans
bisons83914373_bisons
brisant9312683brisant
caimans113811783caimans
divans104612393_divans
diwans105110373_diwans
etesians845473etesians
foisons1047613foisons
gossans836783gossans
grisons838993grisons
ligans76817733_ligans
limans84816303_limans
messans92710463messans
oppidans1343083oppidans
opticians1345543opticians
options93810593opti_ons
origans839973origans
orisons7310563orisons
ovisacs1263283ovisacs
paeans85118263p_aeans
paesan85114093paesan_
paesani9348683paesani
paesano9338793paesano
paesanos10296703paesanos
pagans95717923p_agans
pains75138283pai__ns
paisa76021073paisa__
pans65855723p___ans
parians93519733parians
parsons93516873parsons
partans94418283partans
partisan1058423partisan_
partizans2055243partizans
passant9813943passant
patinas96318523patina_s
patins87528783pati__ns
pavans115715593p_avans
peans75437643p__eans
peasant9314923peasant
peasants1038263peasants
pecans101515833p_ecans
pechans14810503pechans
peins76128063pei__ns
peises84125043peis_es
peising103416763peising
pekans121710553p_ekans
pelicans1238093pelicans
pemicans1447033pemicans
pentosans1145173pentosans
pepsins11310433pepsins
persons93717003persons
petsais938433petsais
phials1158873phi_als
pian66136093p_i_an_
piano76118713p_i_ano
pianos84315933p_i_anos
pias66542553p_i_a_s
pibals103813083p_ibals
picas94626523p_ica_s
pikas114218093p_ika_s
pilafs113511023p_ilafs
pilaus84114133p_ilaus
pilaws11399433p_ilaws
pimas94725103p_ima_s
pinang92611593p_inang
pinangs10267793p_inangs
pinas75434453p_ina_s
pinnas85315513p_innas
pinons86019943p_inons
pins65558453p_i__ns
pions75826393p_i_ons
pipals104213643p_ipals
pirana8713263p_irana
piranas9912603p_iranas
pirns76020093p_i_rns
piscos105112593p_iscos
pishes114722103p_ishes
pisos76021063p_is_os
piss65033333p_is__s
pissant91012503pissant
pissants1097363pissants
pisses84525083p_isses
pistes85325633p_istes
pistons93016373p_istons
pitas77427673p_ita_s
pitman102412123pitman_
pitons85319043p_itons
pitsaw1135613pitsa_w
pittas86014523pitta_s
plans75731273p__lans
platans93413123platans
pliant83918823pli_ant
plisses94411773plisses
poisers94214433poisers
poises84226543pois_es
poising103617103poising
poison8312223poison_
potions93417423poti_ons
primas104418103prima_s
prions84317783pri_ons
prises84133173pris_es
prising103321453prising
prisms104915503pris_ms
prison8514023prison_
priss74623893pris__s
prisses94816713prisses
pristane10310333pristane
pristanes11410423pristanes
prolans9314273prolans
protistans1245203protistans
pterins9812993pterins
ptomains1246053ptomains
ptoses83514673ptos_es
ptosis83611823ptos_is
puisne856353puis_ne
puisnes937423puisnes
puissant10105393puissant
pulsant9310563pulsant
pulsars9358913pulsars
puritans1037633puritans
pyins105815863pyi__ns
pyrans11411063p_yrans
raisins72715343raisins
sans45153353___sans
seisins73614393seisins
seitans73312303seitans
sisals63013573_sisals
taipans9269553taipans
tans46154813_t__ans
ticals83214713_ticals
tigons74112253_tigons
tilaks1097353_tilaks
tins45251303_ti__ns
titan53318173_titan_
titians72710453_titians
tolans64319273_tolans
tomans85419133_tomans
trans54933043_t_rans
tsars56717103_t_sars
unisons748423unisons
visas84317653_visa_s
wigans104511703_wigans
witans93412933_witans

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 Filter1786911340270.1431249587.4
2DLD Change Limit1340271677.73317331.8
3Display Results1671670.0632650.8
 (SQL Overall)1786911677.93922508.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.