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 “paisa” with Change Limit: [1] [2]

(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
paisa7602107(None) 
paisan84417071paisan
paisas84317491paisas
paise75028331paise
ais39083572_ais_
ansa45927772_ansa
apish105116632apish
baiza164813222baiza
balsa77920412balsa
camisa103114322camisa
casa65630862ca_sa
dais57040702dais_
daisy95915312daisy
haika125313792haika
hansa85416782hansa
maist75535682maist
masa65034722ma_sa
massa75518922massa
naira5314742naira
paca85132242pa_ca
pacas96029402pacas
pacha126518062pacha
pacs85842182pacs_
padis86227142padis_
pads76742952pads_
paesan85114092paesan
paid75737482pai_d
paik105726802pai_k
paiks114719852paiks
pail66141832pai_l
pails75833062pails
pain65647242pai_n
pains75138282pains
paint75443692paint
pair66031512pai_r
pairs75325832pairs
paisana94010222paisana
paisano9429512paisano
paisans93614752paisans
palea75028662palea
palish114718272palish
pals66951352pals_
palsy105417462palsy
pampa114913422pampa
pams85641762pams_
panda85022612panda
panga85323532panga
pans65855732pans_
pansy105717972pansy
papa85827142pa_pa
papas94927492papas
papism122211512papism
papist102618742papist
paps86443452paps_
para65242172pa_ra
paras76143042paras
paris75145942paris_
parish115022352parish
parka115120882parka
pars67560792pars_
parse75236992parse
pas58775742pa_s_
pase65346862pa_se
pash95638132pa_sh
pasha105417182pasha
pass65239952pa_ss
passe75525692passe
past65959012pa_st
pasta76624532pasta
patina86022192patina
pats66460852pats_
patsy105717202patsy
pausal81511962pausal
pause75021832pause
pavis106422732pavis_
pavise114714802pavise
paws96038182paws_
pays95940222pays_
peise75825772peise
phis95724902phis_
pia56848032p_i_a
pias66542552pias_
pica85831492p_ica
pika106322952p_ika
pima85428652p_ima
pina65842632p_ina
pis56362032p_is_
pish96127912p_ish
piso66727562p_iso
piss65033332p_iss
pita65436432p_ita
plica9613372plica
pois66539042pois_
poise75127892poise
poisha1135722poisha
praise84419412praise
presa74319042presa
prima95019342prima
prise74632612prise
prism94820262prism
priss74623892priss
psis68120342psis_
ptisan8417972ptisan
raia46638382rai_a
raias54631122raias
rais45252622rais_
raise54828052raise
raita54623072raita
saiga64717932saiga
salsa56718922salsa
taiga64115662taiga
vasa76522972va_sa
visa76323872_visa
waist86132382waist

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001141.62633087.3
3Display Results1141140.0303800.0
 (SQL Overall)1786911141.95291542.5
 
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.