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

161 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
pulis7422560(None) 
pilis75825201pilis
polis74731161polis
pubis94616471pubis
pules74538811pules
puli65527621puli_
pulik113613301pulik
pulls74425051pulls
pulps95116481pulps
puls65437561pul_s
puris75332021puris
aulic74420242aulic
auris55331532auris
bulbs96016932bulbs
bulks115920612bulks
bulls75629572bulls
caulis85320082caulis
coulis84018762coulis
cullis84115992cullis
culls75425812culls
culms95314192culms
cults75022552cults
cutis77723762cutis
delis64928542delis
dulia61014982dulia
dulias71212742dulias
dulls64523742dulls
fujis15379242fujis
fulls84623522fulls
gules64831042gules
gulfs94915302gulfs
gulls65222982gulls
gulps84715072gulps
guls55930852gul_s
hulas84920882hulas
hulks125715482hulks
hulls84923562hulls
kufis1249252kufis
lis37162272__lis
lulls54119652lulls
lulus54315162lulus
mules75034292mules
mulish11311902mulish
mulls75124152mulls
munis75022002munis
nulls55019982nulls
padis86227142padis
pails75833062pails
palais8420422palais
pales75753802pales
palish114718272palish
palls74332562palls
palms94921752palms
palps94719562palps
pals66951352pal_s
paris75145942paris
paulin8312982paulin
paulins9312612paulins
pavis106422732pavis
peles75738082peles
pelfs105016292pelfs
pelts76128812pelts
pelvis113610322pelvis
penis75129322penis
peris75537072peris
phis95724902p_his
pikis115116392pikis
piles74742612piles
pili66130352pili_
pills74130972pills
pilus75921062pilus
pis56362032p__is
plie65127392p_lie
plies74526512p_lies
plugs85213492plugs
plums94619952plums
plus66324832p_lus
pois66539042p_ois
poleis86018352poleis
poles75351002poles
polies84034582polies
polio75722552polio
polios84019722polios
polish114916722polish
polls74627722polls
polos76129912polos
pols66044562pol_s
polys105718762polys
poults84613482poults
psis68120342p_sis
pubes94423402pubes
pubic114513722pubic
public12238142public
publics13207142publics
publish1447912publish
pubs85029212pu_bs
puces94924632puces
pucks134322102pucks
pudic104614562pudic
puds75630512pu_ds
puffs134114932puffs
pugs76332772pu_gs
pujas145513322pujas
pukes114523022pukes
pul56138062pul__
pula65129372pul_a
pule65040952pul_e
puled84926522puled
puler74826622puler
pulers83820282pulers
puling93621402puling
pulings103511322pulings
pull64731662pul_l
pulp84825352pul_p
pulpit10310932pulpit
pulpits1137242pulpits
pulpy124612362pulpy
pulse74219972pulse
pulses83818662pulses
pumas95121562pumas
pumps115520602pumps
punas74826752punas
pungs85422222pungs
punish111411502punish
punjis1536692punjis
punks114822682punks
puns66641482pu_ns
punts75828002punts
pupas95219282pupas
pupil94712982pupil
pupils10389912pupils
pups86032232pu_ps
pupus94614042pupus
puri65931442puri_
purin75527592purin
purins83722652purins
purism104715062purism
purist85525052purist
purlin83615862purlin
purlins93415422purlins
purls74723352purls
purrs75320432purrs
purs65641042pu_rs
pus55547842pu__s
puses75532202puses
puss64830132pu_ss
puts65641752pu_ts
putts75719272putts
pyxis17458632pyxis
quais144618392quais
rules55234252rules
sulks94818462sulks
sulus54821882sulus
sylis84316022sylis
tuis44829642tu_is
tules54532792tules
tulip71111692tulip
tulips8137252tulips
ulus45622562_ulus
uplit76020802uplit
yules84521582yules

Search took 7 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.593301333.9
2DLD Change Limit538001615.5939619.2
3Display Results1611610.0931731.2
 (SQL Overall)1786911616.27928458.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.