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

104 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
psoas7501298(None) 
proas75028801proas
psoae74411621psoae
psoai7469921psoai
anoas57226492anoas
boas66150832_boas
goas55239942_goas
isbas71010402isbas
koas85635092_koas
moas65545342_moas
pacas96029402pacas
papas94927492papas
paras76143042paras
pas58775742p__as
pashas115117062pashas
pastas85422872pastas
peas65755062p_eas
peons75327182peons
pesos77221622peso_s
phons105221142phons
phots105418502phots
pias66542552p_ias
picas94626522picas
pikas114218092pikas
pimas94725102pimas
pinas75434452pinas
pions75826392pions
pious74621272pious
pisos76021062piso_s
pitas77427672pitas
pleas75627032pleas
plods85719292plods
plops95920332plops
plots75025672plots
plows105419902plows
ploys105816592ploys
pods76540152p_ods
pois66539042p_ois
pols66044562p_ols
poms87037742p_oms
pons65850602p_ons
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poons75430972poons
poops94422412poops
poos65949112p_oos
pops86340952p_ops
poses74642762poses
posts75228782posts
pots66452362p_ots
pows95537662p_ows
praos74923562praos
proa66229962proa_
prods85523552prods
profs105120892profs
progs86624152progs
proms95426412proms
props95726882props
pros65742782pro_s
pross76529402pross
prows106327012prows
pshaw13447512pshaw
pshaws14435702pshaws
psis68120342ps_is
psyops1334342psyops
pujas145513322pujas
pumas95121562pumas
punas74826752punas
pupas95219282pupas
pyas96225702p_yas
seas45755272_seas
skas85325712_skas
soak87227662_soak
soaks95220292_soaks
soap65831132_soap
soaps75120712_soaps
soar46838672_soar
soars54732512_soars
sobas74424252_sobas
sobs64941752_sobs
socas74026182_socas
sodas64123542_sodas
sods54940212_sods
sofas85320712_sofas
sojas124716392_sojas
sols45448162_sols
somas76030372_somas
soms66239372_soms
sons46049552_sons
sops65244562_sops
soras55041012_soras
sos37761602_so_s
sots45552452_sots
sous46947212_sous
sows75342492_sows
soyas84520912_soyas
soys75233932_soys
spas67036722_spas
spots74424112spots
stoas55126022stoas
upsoar8105682upsoar
upsoars985412upsoars

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 Limit538001041.50035866.7
3Display Results1041040.0303466.7
 (SQL Overall)1786911041.82697859.3
 
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.