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

59 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
personals1123857(None) 
personal102311571personal_
personas102511881persona_s
persona92812452persona__
personable1467072personable
personae102410552persona_e
personage12226712personage
personages13276532personages
personalise1367102personalise
personalism15137392personalism
personalist1399422personalist
personally1546942personally
personalty1555282personalty
personate112111422personate
personates122510692personates
personnels1243202personnels
persons93717012person__s
seasonals945282seasonals
arsenals847733_arsenals
coronals103312893cor_onals
impersonal1454743impersonal_
parsonage12225583parsonage
parsonages13255663parsonages
parsons93516873parson__s
passionals1244803passionals
pectorals13128153pectorals
pedocals1346083pe_docals
perennials1244893perennials
pereons92815003pereon__s
pergolas1158233pergola_s
peroneal1049173per_oneal_
peroral9314793per_oral_
perrons93115483perron__s
persalt9315413pers__alt
persalts1038193pers__alts
person83517873person___
personalised1554443personalised
personalises1476523personalises
personalisms1676093personalisms
personalists1476503personalists
personality1656333personality
personalize2287333personalize
personalizes2356703personalizes
personalties1485153personalties
personated13258293personated
personator1245853personator
personators1345543personators
personify1744013personify
personnel1143733personnel
perusals1047143per_usals
petronels1146063petronels
piperonals1453183piper_onals
presignals1363843presignals
presoaks1436603preso_aks
regionals10286413regionals
seasonal847263seasonal_
seconals1047053se_conals
terminals1147453terminals
versional1245863versional_

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 Filter1786911486410.423422437.4
2DLD Change Limit148641596.61022487.3
3Display Results59590.0301966.7
 (SQL Overall)178691597.06325299.6
 
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.